This content has been marked as final.
Show 3 replies
-
Re: Dimension limitation with expression
Karthik Selvaraj Sep 12, 2017 3:55 AM (in response to Philippe BONNIN)Hi Philippe,
Please use the below expression in your measure
=IF(CATTC_REEL< CIB_CATTC ,CATTC_REEL,0)
=IF(CATTC_REEL< CIB_CATTC ,CIB_CATTC ,0)
and in addons please disable the show zero values.
Many Thanks
Karthik
-
Re: Dimension limitation with expression
Philippe BONNIN Sep 12, 2017 4:27 AM (in response to Karthik Selvaraj)Hi Karthik ,
great trick !
obviously i added sum( ...) , and it's working !
i thank's you for that
the disadvantage is when i have 10 more measures with aggr expression for example, i have to apply the trick for all ... rather complicated
Anyway ... if there's no alternative with the dimension limitation or other fonctionality , i take your trick !
best regards
Philippe
-
Re: Dimension limitation with expression
Anand Chouhan Sep 12, 2017 4:35 AM (in response to Philippe BONNIN)You can do this calculation in the load script if you have many calculations on the script part you can handle it properly and it is optimized way as well.
-
-