Forum Discussion

RameshSingh's avatar
RameshSingh
Qrew Member
2 years ago

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 it is X,Y,Z, then sum of (X,Y,Z))
Can it be possible to be created in qb natively?

Thanks

------------------------------
XYZ
XYZ
------------------------------
  • RameshSingh's avatar
    RameshSingh
    Qrew Member
    2 years ago
    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
    ------------------------------
    • RyanBuschmeyer1's avatar
      RyanBuschmeyer1
      Qrew Trainee
      2 years ago
      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
      ------------------------------