Dear Team,
It would be good if we have IF or IFS function directly in calculation stage by this we can avoid multiple decision stages. sometimes we have to do complex logical conditions and for that we have to multiple decision stages
IF(condition, value_if_true, value_if_false)
IF(condition, value_if_true, If(condition2,value_if_true,value_if_false))
IF(condition1 And condition2, value_if_true, value_if_false)
Or probably this version of IF function using IFS, without multiple nested if
IFS([Status]="Open" And [Amount] > 1000, "High",[Status] = "Pending", "Medium","Low")
IFS(condition , value_if_true, condition2, value_if_true, else_value)
this change will make developer life easy , business rules will become clear and structure , more reliable and faster to build
Thank you
Mohammad Naveed
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.