Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

3 different values

Hi Team,

I want my column based on my baseline value, if my Q1 is less than Baseline then No if it is equal to Baseline then Yes, if the Q1 is 0% then N/A.

 

 

Please help me

Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

     

    Result CC =
    SWITCH (
    TRUE (),
    Data[Q1] = 0, "N/A",
    Data[Q1] < Data[BaseLine], "No",
    Data[Q1] = Data[BaseLine], "Yes"
    )

     

     

1 Reply

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    5 years ago

     

    Result CC =
    SWITCH (
    TRUE (),
    Data[Q1] = 0, "N/A",
    Data[Q1] < Data[BaseLine], "No",
    Data[Q1] = Data[BaseLine], "Yes"
    )