Calculated dimension

[#1]

It is even possible to use the value of the Calculated dimension in expression

For example:

Calculated dimension- Aggr(Sum(Stock),Date)

Expression- Count(distinct  if(Sum(Sales)>'Calculated dimension',Date))

[swuehl]

You should be able to just use sum(Stock) instead of 'Calculated dimension' here. But since you embed an aggregation (sum()) into another aggregation function, you'll need to use advanced aggregation aggr() function here, too.

Or try:

=count({<Date = {"=sum(Sales)>sum(Stock)"}>} distinct Date)

[#3]

I do not care what happens in the expression and Calculated dimension,  I'm interested in the possibility of using the value of the Calculated dimension In expression

Calculated dimension=2

Expression= if(Calculated dimension=2,"two",null())

[swuehl]

And replacing your 'Calculated dimension' with the expression you are using in the aggr() function should / could work fine.

edit:

Ok, this only works if you only get one distinct underlying dimension value, back (i.e. Date in your sample). In general, you need to repeat the complete calculated dimension.

[#5]

I can not

formula will work correctly only in Calculated dimension

[swuehl]

Could you post a small sample app? Or your complete dimension and expression definitions?

[#7]

i can not

[#8]

I am interested in only one thing, is it possible to get the value of the Calculated dimension in expression

[swuehl]

If you have a calculated dimension like

=Aggr(Sum(Stock),Date)

an expression like

=Aggr(Sum(Stock),Date)

returns the dimension value. There is no function to "call" the calculated dimension value directly, AFAIR (edit: sorry, for the acronym,  http://en.wiktionary.org/wiki/AFAIR).

[#10]

not understood.

what is it afair?