Forum Discussion

novicenovice's avatar
novicenovice
Icon for Helper I rankHelper I
6 years ago

Issue on variable within measurement - No result, No error

  Dear all,   I have an issue on my calculation of my variable IDDLP in Fig 1 which determinate the max date and used directly in  my measurement fig3. The calculation run run whithout providing t...
Need Help
v-xicai's avatar
v-xicai
Icon for Community Support rankCommunity Support
6 years ago

Hi novicenovice ,

 

You may need to sort out the formula's logic, there are too much VAR statements nested in the SUMX and GROUPBY function. You can use VAR statement one by one, the next VAR statement can refer to the last VAR statement, then use a RETURN statement to return the final result.

 

 

 

Best Regards,

Amy

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

novicenovice's avatar
novicenovice
Icon for Helper I rankHelper I
6 years ago

Hello Amy,

 

I'm sorry but I don't understand your recommendation as my english is quite basic.

 

Could you relaborate it by providing an example ?

 

Thanks

 

Novice