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
Solved! Go to Solution.
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.