Hello,
I want to exclude some types of my calculated measure.
So I need to define a flag. My approach was to define a variable in the UI.
vFlag: if( TYPE='A', 1,0)
Then I created a master element Using this Formula (and lots of variations):
mRevenue:
Sum(If(($(vFlag),REVENUE,0)))
Sum(If(($(vFlag)=1,REVENUE,0)))
There is no syntax error. No results.
What's wrong here ?
And what are your experiences with the handling of measures in the UI ?
Thanks in advance!