Forum Discussion
Nested If And Statement
Hi,
I have this formula in BO but am getting error when converting to PBI.
Date Range
=If [Days for Approval] = "Not Approved" Then [Days for Approval]
ElseIf ([Days for Approval (Numeric)]>=0 And [Days for Approval (Numeric)] <=3) Then "0 - 03 Days"
ElseIf ([Days for Approval (Numeric)] > 3 And [Days for Approval (Numeric)] <= 7) Then "04 - 07 Days"
ElseIf ([Days for Approval (Numeric)] > 7 And [Days for Approval (Numeric)] <= 15) Then "08 - 15 Days"
ElseIf ([Days for Approval (Numeric)] > 15 And [Days for Approval (Numeric)] <= 30) Then "16 - 30 Days"
ElseIf [Days for Approval (Numeric)] > 30 Then "31+ Days"
Thank you for the feedback.
Use this
Date Range = SWITCH( TRUE(), [Days for Approval] = "Not Approved", [Days for Approval], [Days for Approval (Numeric)]>=0 && [Days for Approval (Numeric)] <=3, "0 - 03 Days", [Days for Approval (Numeric)] > 3 && [Days for Approval (Numeric)] <= 7 , "04 - 07 Days", [Days for Approval (Numeric)] > 7 && [Days for Approval (Numeric)] <= 15 , "08 - 15 Days", [Days for Approval (Numeric)] > 15 && [Days for Approval (Numeric)] <= 30, "16 - 30 Days", [Days for Approval (Numeric)] > 30 , "31+ Days" )
2 Replies
Use this
Date Range = SWITCH( TRUE(), [Days for Approval] = "Not Approved", [Days for Approval], [Days for Approval (Numeric)]>=0 && [Days for Approval (Numeric)] <=3, "0 - 03 Days", [Days for Approval (Numeric)] > 3 && [Days for Approval (Numeric)] <= 7 , "04 - 07 Days", [Days for Approval (Numeric)] > 7 && [Days for Approval (Numeric)] <= 15 , "08 - 15 Days", [Days for Approval (Numeric)] > 15 && [Days for Approval (Numeric)] <= 30, "16 - 30 Days", [Days for Approval (Numeric)] > 30 , "31+ Days" )