Scenario Currency 1 Currency 2 If C1=C2 Expected Output
======== ========== ========== ======== ===============
1 * Null False *
2 Null * False *
3 * Not Null False *
4 Not Null * False *
5 * * True *
6 Null Null True Null
7 Not Null Not Null True Currency 1
8 Not Null Not Null False *
9 Not Null Null False Currency 1
10 Null Not Null False Currency 2
=If(Currency 1="*" Or Currency 2="*" Or (Not (IsNull(Currency 1)) And Not (IsNull(Currency 2)) And (Currency 1<>Currency 2));"*";If((Currency 1=Currency 2) Or IsNull(Currency 2);Currency 1;Currency 2)).
Considering the above example of Revenue=A+B+C, the above logic has to be used twice, once between A and B and a second time between C and previous result of A and B to arrive at the unit/currency of Revenue .
Have a question about something in this article? You can receive help directly from the article author. Sign up for a free trial to get started.
Comments (0)