Forum Discussion
Solved
NESTED IF
ifmeasure =
IF( [cost] =0, [measure1],
IF ([cost]<>0, [measure2]
)
)
this code should be returning two different values depending on the cost but it always ends up taking up only the first measure.
would be great if i could have some guidance over it
IF( [cost] =0 || isblank([Cost]) , [measure1],[measure2]
)
2 Replies
IF( [cost] =0 || isblank([Cost]) , [measure1],[measure2]
)Much thanks for the quick solution.
