Problem with context calculation

[Former Member]

Dear all,

I'm facing another context calculation problem in BO.
I created a table with one calculated field as a Dimension.
At the end of this table, I'm summing up this field, counting the number of unique IDs and building the average based on these numbers:

This works perfectly and the calculation is correct. I put the formula for the "Avg days per ID" calculation directly in the cell:

=(Sum([DaysBetween])/Count([Reference Number];Distinct))

Now I want to display this very number (2.44) on a separate tab in this document. Every time I try to create this formula and save it as a variable and put it into any other place than at the bottom of this table it gives me a MULTIVALUE error.

How can I reference to this table to put the formula into context?

Thanks in advance for your help!

[Former Member]

Thanks for your responses Amit, Niraj! Unfortunately, both do not work. When I create a variable (measure) with the formula it just displays MULTIVALUE.

Any other ideas?