Positive and Negative Values to capture with Count

[Aanchal]

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 . 

[vinieme12 · Accepted solution]

Expression for Mismatch column

=if(sign(min(total <Pol> GrossPremium))<>sign(max(total <Pol> GrossPremium)),sum(GrossPremium))

[Aanchal]

Thank You