3 Replies Latest reply on Feb 28, 2018 1:40 PM by Deepak Rai

    Nested IIF statement?

    albert wong

      I'm using the IIF function to label "unknown" values as "120+ Days".

       

      I'd like to make the IIF apply to all bucket ranges in the event "VA" product has no matches however i keep getting an error

       

      Below is the current valid calculation however i'm wondering if there is a way to nest the IIF to apply to all ranges?

       

      Thanks in advance!