needmoremoney
Technical User
Hi all,
I need help with this, hope someone can help. Thanks ahead of time.
I have two fields. CollumnA and CollumnB
I want to compare the values. If they are the same then I only want to output what is in field A. (If both are zeros then output blank".
If they are different, but if either field is a zero, then I want to output only the value that is not equal to zero.
If they are different, but neither values are equal to zeros then I want to output both values.
Sample data:
Field A Field B
1 1
2 2
3 3
4 0
0 5
0 0
3 6
OUTPUT SHOULD LOOK LIKE THIS:
1
2
3
4
5
(blank spot)
3,6
......
Thanks for any help.
I need help with this, hope someone can help. Thanks ahead of time.
I have two fields. CollumnA and CollumnB
I want to compare the values. If they are the same then I only want to output what is in field A. (If both are zeros then output blank".
If they are different, but if either field is a zero, then I want to output only the value that is not equal to zero.
If they are different, but neither values are equal to zeros then I want to output both values.
Sample data:
Field A Field B
1 1
2 2
3 3
4 0
0 5
0 0
3 6
OUTPUT SHOULD LOOK LIKE THIS:
1
2
3
4
5
(blank spot)
3,6
......
Thanks for any help.