Skip to main content
Announcements
Marching toward a simplified navigation! READ ON
cancel
Showing results for 
Search instead for 
Did you mean: 
Architect
Partner - Creator
Partner - Creator

Using master measures in IF statement.

I have 3 master measures.

M_total,

M_app,

M_max.

Now we have to create an if statement that will give us colour output.

If M_total less than M_app colour is green .

And if M_total more than M_app colour is red .

What would be the code?

Labels (1)
3 Replies
MendyS
Partner - Creator III
Partner - Creator III

Hi @Architect 

try - 

IF(M_total<M_app ,Green(),Red()) 

what do you want to do if M_total is equal to M_app?

 

Architect
Partner - Creator
Partner - Creator
Author

Not working.

These are measures, having wrong op

MendyS
Partner - Creator III
Partner - Creator III

@Architect 

OK

can you send a screenshot of the error that you got?