Skip to Content
0
Jun 17, 2020 at 12:01 PM

Looping on variable in data action trigger(advanced formula)

390 Views

Hello experts,

I am creating a Data Action trigger for a planning model as below. I want to loop multiple times on a variable value which is populated via a measure. ex: Value of variable is 4(populated from Resultlookup of End of Furlough) and I want to loop 4 times on the variable.

Though I am able to loop on any dimension member, there is no way I can loop on any variables.

In case looping on variable is not possible is there any way I can loop on a dimension member multiple times based on its value. Ex: If value of End of Furlough is 4, can I loop on it for 4 times?

Please help.. Thank you in advance!

Attachments

zypq5.png (5.7 kB)