IF Condition

Beast mode calculation needed..

If 'Model' value contains blank then ignore those column of data and take of rest of rows

model

example

1 20

2 --- blank

3 40

here we need to ignore 2nd rows

Best Answer

  • GrantSmith
    GrantSmith Coach
    Answer ✓
    CASE WHEN `model` IS NULL THEN 'Ignore' ELSE 'Include' END
    

    You can then take that beast mode and filter it on your card for Include

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Answers