Scripting expression

[Zaga_69]

Hi all,

I created a island-table to create an scaling factor (i.e. Million, Thousand, Full). When using this field in my Set Analysis, it does not work properly. when the end-user select the scaling factor, for example Million, the formula, the highlighted one in yellow, just calculates the number correctly for the period selected and not for the other ones. Any idea?

Thanks

Edi

[Lisa_P]

It could be because of the Period={"<=$(=max(Period))"} - the max period is 4

[Vegar · Accepted solution]

What happens if you exclude the ScalingNumber form the expression? Does it calculate for all rows?

Your output seems strange, but using a dollar expanded ScalingNumber should remove all issues with it. Try replacing ScalingNumber with $(=only(ScalingNumber)) .

[Zaga_69]

Many thanks Vegar. It works now!