Dear All ,
I have three Measures as expression on frontend in straight table
Refund/Endorsement, Premium Pending and Premium Mismatch
| Trankey |
Countnew |
Debtors_type |
days_ageing |
Premium Mismatch |
Premium Pending |
Refund/Endorsement |
| 22A01512|0 |
2 |
Non OEM |
0-15 Days |
296 |
296 |
0 |
| 22A01512|0 |
2 |
Non OEM |
More than One Month |
-1232 |
0 |
-1232 |
| 22A03761|4 |
1 |
Non OEM |
0-15 Days |
- |
0 |
-6182.12 |
| 22A07336|0 |
1 |
Non OEM |
More than One Month |
- |
0 |
-13245 |
| 22A11806|3 |
1 |
Non OEM |
0-15 Days |
- |
47200 |
0 |
| 22A13117|0 |
1 |
Non OEM |
16-31 Days |
- |
1586805 |
0 |
| 22A13117|4 |
1 |
Non OEM |
16-31 Days |
- |
0 |
-420375.02 |
| 22A14876|0 |
1 |
Non OEM |
16-31 Days |
- |
0 |
-24339 |
Requirement :
when it finds Premium Mismatch the columns Refund and Premium Pending should return 0. Please guide.
