Report filter question
I have a multiple choice field which has three options X, Y,Z I am working on creating a formula field for the dashboard. The logic is (if it is Y, then Y and if it is X,Z then sum(X,Z) and if i...
Forum Discussion
I ended up doing a formula text field but it shows me error for using or.
Split(List(" ; ",
If([Flag]="X" , "X + Y"),
If([Flag]="Y" , "X + Y"),
If([Flag]="Z", "Z"),
If([Flag]="X" or "Y" or "Z", "X + Y +Z"),
""))
------------------------------
XYZ
XYZ
------------------------------
Split(List(" ; ",
If([Flag]="X" , "X + Y"),
If([Flag]="Y" , "X + Y"),
If([Flag]="Z", "Z"),
If([Flag]="X" or "Y" or "Z", "X + Y +Z"),
""))
------------------------------
XYZ
XYZ
------------------------------
I think you have a loop in your logic:
If Flag = X, then "X + Y" but then you also have if flag is X or Y or Z... this is a conflict.
BUT... in these instances you want to user CASE instead of IF
https://login.quickbase.com/db/6ewwzuuj?a=dr&rid=136
CASE(
"Y", Y,
"X,Y", X + Y,
"X,Z", X + Z,
"X,Y,Z", X + Y + Z)
etc... it is basically a "for each of these instances...do this"
------------------------------
Ryan Buschmeyer
------------------------------
If Flag = X, then "X + Y" but then you also have if flag is X or Y or Z... this is a conflict.
BUT... in these instances you want to user CASE instead of IF
https://login.quickbase.com/db/6ewwzuuj?a=dr&rid=136
CASE(
"Y", Y,
"X,Y", X + Y,
"X,Z", X + Z,
"X,Y,Z", X + Y + Z)
etc... it is basically a "for each of these instances...do this"
------------------------------
Ryan Buschmeyer
------------------------------
