Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I would like to reuse a calculated value from a diagram in another diagram. Or a new formula that produces just this result.
I have attached an Example Script to show my Problem.
Unfortunately i cant do this in my Datamodel <-- so I would like to do it this way.
Thanks
Markus
In a text box object? May be this
=Sum(Aggr(If(sum(Expression3/Expression1) >= 6, 1, 0), Dim1))
In a text box object? May be this
=Sum(Aggr(If(sum(Expression3/Expression1) >= 6, 1, 0), Dim1))
.
Where? You have not shared any link my friend?
Hi,
now I have the Problem, that I wan´t to use a set expression in my Formula.
=Sum(Aggr(If(sum( <SetExpression> Expression3/Expression1) >= 6, 1, 0), Dim1))
for example DIM2 should be "c" is this possible?
It results in Nested expressions are not allowed...
Kind Regards,
Markus
Like this?
=Sum({<DIM2 = {'c'}>}Aggr(If(sum({<DIM2 = {'c'}>}Expression3/Expression1) >= 6, 1, 0), Dim1))
Thank you! Solved my Problem!
Regards,
Markus