Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Variables and Flags

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!

0 Replies