IF Condition

RajNadar · 2022-07-19T19:00:45+00:00

There was an error rendering this rich post.

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

Find more posts tagged with

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 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.

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

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

Thanks