Report Builder

lep

I have searched but can't find an answer. I am building a report and want to set 'what' as the following:

"is a number

does not contain - total"

However the 'exclude selected items' checkbox only seems to operate for all conditions and I therefore cannot get the desired combination (I can have is not a number and does not contain or I can have is a number and contains total). 

Does somebody have a simple workaround for this?

Laura

Andrée Starå

Hi Laura,

Which columns/cells is the What criteria looking at?

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Paul Newcome

If a cell registers as having any text in it, it will not register as a number. You should be able to just set your criteria as being a number, and not worry about specifying to not include specific text.