Take value from dimension in expression

[danosoft]

Hi, i  have a table chart with some dimension.

Is possible to take the value of an dimension ('coefficiente') in an expression in another dimension?

Dimesion

Expression

Thanks

[YoussefBelloum]

Hi,

what you're trying to do exactly ?

calculating an expression for one value of that dimension ?

[danosoft]

Yes, my dimension is COEFFICIENTE, and i want  calculate my expression (as you saw in the example) using my dimension

[YoussefBelloum]

If you want to calculate your measure using your dimension, you should put the dimension in the "dimension" tab, not in the expression tab.

so move COEFFCIENTE to the dimension tab

[shiveshsingh]

But COEFFCIENTE is dimension, what you want to calculate?

[danosoft]

no sorry, is not that, i have two dimension

1. COEFFICIENTE

2. Punti

i want use this dimension COEFFICIENTE, in the expression of the dimension Punti in this way (this is the expression i have in my dimension Punti):

Sum({<POD = {"=Sum(CONSUMO_TOTALE_KWH)/([coefficiente]*12) < 1000"}>} [coefficiente])

is possible to do that?

[YoussefBelloum]

Would you be able to share a sample QVW to take a look ?

[qv_testing]

As per my understand,

This expression using in Dimension, right ??

Sum({<POD = {"=Sum(CONSUMO_TOTALE_KWH)/([coefficiente]*12) < 1000"}>} [coefficiente])

If, i'm right

try this...

Aggr(Sum({<POD = {"=Sum(CONSUMO_TOTALE_KWH)/([coefficiente]*12) < 1000"}>} [coefficiente]), coefficiente)

[YoussefBelloum]

you mean this ?

Aggr(ONLY({<POD = {"=Sum(CONSUMO_TOTALE_KWH)/([coefficiente]*12) < 1000"}>} [coefficiente]),coefficiente)

[YoussefBelloum]

I tried this out and actually both are working with a set of data I have..

d.caprelli‌ you can test it and remove your dimensions from the "expression tab"