Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
I am stuck in a development part where i need to capture both positive and negative value along with count in a column in pivot
Pol | Tranno | Gross Premium | Refund | Premium | Mismatch |
1 | 1 | 10 | 10 | ||
1 | 2 | 20 | 20 | ||
2 | 1 | -20 | -20 | ||
3 | 1 | -30 | -30 | ||
3 | 2 | -40 | -40 | ||
4 | 1 | 10 | 10 | ||
4 | 2 | -20 | -20 |
Where my Policy count is more than 2 and SIGN od Gross Premium is positive and negative i need to move that gross premium amount in mismatch column .
Expression for Mismatch column
=if(sign(min(total <Pol> GrossPremium))<>sign(max(total <Pol> GrossPremium)),sum(GrossPremium))
Expression for Mismatch column
=if(sign(min(total <Pol> GrossPremium))<>sign(max(total <Pol> GrossPremium)),sum(GrossPremium))
Thank You