Forum Discussion

hulk_deka's avatar
hulk_deka
Frequent Visitor
4 years ago
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 m...
General Comment
Need Help
Show and Tell
  • amitchandak's avatar
    amitchandak
    4 years ago

    hulk_deka ,

    IF( [cost] =0 ||  isblank([Cost]) , [measure1],[measure2]
    )

hulk_deka's avatar
hulk_deka
Frequent Visitor
4 years ago

Much thanks for the quick solution.