Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
No , its not giving the desired output.