Using Pre-calculated value

[mmainiero]

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

[sunny_talwar · Accepted solution]

In a text box object? May be this

=Sum(Aggr(If(sum(Expression3/Expression1) >= 6, 1, 0), Dim1))

[xyz1]

.

[sunny_talwar]

Where? You have not shared any link my friend?

[mmainiero]

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

[sunny_talwar]

Like this?

=Sum({<DIM2 = {'c'}>}Aggr(If(sum({<DIM2 = {'c'}>}Expression3/Expression1) >= 6, 1, 0), Dim1))

[mmainiero]

Thank you! Solved my Problem!

Regards,

Markus