Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello at all,
i want create a dynamic dimension:
i have 3 Formulas:
Dynamic Dimension | Formula 1 | Formula 2 | Formula 3 |
---|---|---|---|
if([Formula 1] = 0, 'YES, 'NO') | = fabs([Formula 3] - [Formula 2]) | = sum(x) | = sum(y) |
YES | 0 | 10 | 10 |
NO | 5 | 10 | 5 |
How can i create such an dynamic dimension? i can't work with a Dynamic Dimension and [Formula 1] Expression
You need to think about what the real dimension is behind this calculated dimension. Meaning, what do you want to sum(x) and sum(y) over? Let's say it's "Product". Then your calculated dimension would look like this:
aggr(
if(fabs(sum(x)-sum(y))=0,'YES','NO')
,Product
)
Regards,
Vlad
this looks like some kind of recursive or cyclic definition.
How can a calculated dimension depend on an expression that evaluates based on the dimension?
I don't think this is possible.
regards
Marco