Forum Discussion

M_SBS_6's avatar
M_SBS_6
Helper V
3 years ago
Solved

IF statement using Measures

Hi,    I have 2 measures (apps_val and comps_val) of which I need to create a text output on based on the following logic. How would I correctly write this out please?    If apps_val > comps_val ...
Need Help
  • ddpl's avatar
    ddpl
    3 years ago
    Measure = If([apps_val] > [comps_val] && [comps_val] > 0 , "uplift", 

                   If [apps_val] < [comps_val] && [apps_val] <>0 , "not required", 

                         If [apps_val] > 0 && [comps_val] ==BLANK(), "test",0)
ddpl's avatar
ddpl
Solution Sage
3 years ago
Measure = If([apps_val] > [comps_val] && [comps_val] > 0 , "uplift", 

               If [apps_val] < [comps_val] && [apps_val] <>0 , "not required", 

                     If [apps_val] > 0 && [comps_val] ==BLANK(), "test",0)