I have a column which shows Values in ($1234.56) that is coming from [Original Number] and another value that is coming from the [Second Number].

The Formula I am using is:

If(IsNull([Original Number])) Then([Second Number]) Else([Original Number])

Unfortunately that hasn't been giving me the ([Second Number]) and for some reason keeps Showing me $0.00 which is in the [Original Number] field.

Is there a way I can change the formula to make it overlook the 0.00 value??

Thank You

try this.

=If(IsNull([Original Number]) or ( [Original Number]=0)) Then([Second Number]) Else([Original Number])

You already have an active moderator alert for this content.

## Add comment