on 05-04-2017 8:31 PM
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 must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.