Filter node - filtering on numeric

[mgirdwood]

Hi

I am trying to filter out rows based on whether both columns have an integer 0

It seems the use of "contain" only works for strings ie

Contains([Actuals [EUR]]],0) OR Contains([Budget [EUR]]],0)

Please can someone point me towards the numeric version of "contains" ?

thanks

Mark

[JosephSerpis]

Hi @mgirdwood you would need to use = for numeric arguements

[mgirdwood]

Hi Joseph

Thansk for the quick reply - I tried both the following but get a parse error for both so i guess I am missing something else

Contains([Actuals [EUR]]], = "0") OR Contains([Budget [EUR]]], = "0") 

or 

Contains([Actuals [EUR]]], = 0) OR Contains([Budget [EUR]]] ,  = 0)

[JosephSerpis · Accepted solution]

Hi @mgirdwood contains is a string arguments therefore for a numeric arguments all you need is the column and the sign = or not equal to != to filter numeric data. Try filtering on one column first using a basic filter then switch to a custom filter afterwards as it will build out the syntax as a formula for the first column then hopefully you be able to workout out how to filter with the second column.

[binuacs]

@mgirdwood 

Contains([Actuals [EUR]], "0") OR Contains([Budget [EUR]], "0")