Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

greater than

Hi,  It might be an easy question but I can't figure out the correct method.  I have a category list  Category  Sub A 1 A 2 B 3 B 4       Timestamp Value Sub 5/6...
help and show
PabloDeheza's avatar
PabloDeheza
Icon for Solution Sage rankSolution Sage
4 years ago

Hi there!

You could try something like this:

SWITCH(

TRUE(),

Sub = 3 && Value > 60, TRUE,

Sub = 3 && Value <= 60, FALSE,

Sub = 1 && Value > 50, TRUE,

Sub = 1 && Value <= 50, FALSE,

BLANK()

)

Let me know if that help!

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi PabloDeheza, 

    Is create a new column or use new measure? 

    • PabloDeheza's avatar
      PabloDeheza
      Icon for Solution Sage rankSolution Sage
      4 years ago

      That way would be for a calculated column

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi PabloDeheza , 

    There shown error in this code. 

    FYI, this are my two table. 

     

    Thanks for your help. 

     

    • PabloDeheza's avatar
      PabloDeheza
      Icon for Solution Sage rankSolution Sage
      4 years ago

      Make sure to refer to the corresponding column and table, I used sub and value as an example, but it would be 'Total Value'[Sub] and 'Total Value'[Value] instead of just "Sub" and "Value". Also make sure you create this calculated column in Total Value table

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Hi PabloDeheza, 

        However, I have a list of the value 

        TimestampValueSub
        5/6/2251
        5/6/22431
        5/6/22201
        5/6/2262

         

        I wish to get the sum from sub 1 and the value if >50 then true, sub 2>20 then true

         

        So it will be telling me true for 1 because is 68 while false for 2 <20. 

        Are there any method to do this? 

         

        Thanks for your help.