Filter node - filtering on numeric

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

Workflow

Accepted answers

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.

All comments

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

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)

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.

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

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703