IF Condition

RajNadar · July 2022

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

GrantSmith · July 2022

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

MichelleH · July 2022

@RajNadar It sounds like you need a CASE statement. You can read more about how these work in this Knowledge Base article: https://domohelp.domo.com/hc/en-us/articles/360043429933-Beast-Mode-Functions-Reference-Guide#2.3.

Ashleigh · July 2022

case

when Model is null then 'Ignore'

else 'Keep'

end

Then you can filter on Keep

Alternatively, you could also do

ifnull(Model, 'Blank')

then filter out Blank

GrantSmith · July 2022

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

RajNadar · July 2022

Thanks

Best Answer