Return null value in equation

Help Center Get Answers
1

Hi there,

I was wondering if there was any way to return a null value in an equation as part of a ternary operator. For example:

{Value} == 1 ? {Value} : null

Right now, this would return a 0 - which doesn't working for me as I'm trying to use it in concert with the 'exclude empty columns' option for tables.

Cheers,

Adam

2

Any input on this? I really need to return a {blank} or null value here, not a zero... If you return a zero, then it screws up average calculations among other things... My current scenario is different, but I am also wondering if there is a way to have a completely "blank" cell returned after a particular formula or response.

I even tried setting the response to a separate field which I intentionally leave blank, but this also defaults to a value of $0.00.

Help?