Dear All,
Kindle help me in achieving
TranKey |
Amount |
Refund |
Premium |
Mismatch |
1 |
100 |
|
100 |
100 |
1 |
-30 |
-30 |
|
-30 |
This is my table in frontend where Trankey , Amount , refund and Premium are calculated on backend and for Mismatch is an expression
=if(sign(min(total<Trankey> [Amount]))<>sign(max(total<Trankey>[Amount])),[Amount])
I have to show a condition in expression on frontend where Mismatch is coming Refund and Premium should be Blank.
TranKey |
Amount |
Refund |
Premium |
Mismatch |
1 |
100 |
|
|
100 |
1 |
-30 |
|
|
-30 |
This is the correct output i have to achieve.