Skip to main content
Question

Report filter question

  • November 30, 2022
  • 0 replies
  • 21 views
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
------------------------------
    This topic has been closed for replies.

    • RameshSingh
    • Author
    • Quickbase Alumni
    • November 30, 2022
    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
    ------------------------------
    Terms & ConditionsAccessibility statement