% Calculation

[upaliwije]

Hi Friends

I have written following expression and bus It does not calculate the % correctly. Pls help me correct my expression

if(RENEWED_PREMIUM=0 or (RENEWED_REFUNDS*1)=RENEWED_PREMIUM,SUM( RENEWABLE_PREMIUM))

/if(RENEWED_PREMIUM=0 or (RENEWED_REFUNDS*1)=RENEWED_PREMIUM,SUM(TOTAL<REASON> RENEWABLE_PREMIUM))

[sunny_talwar]

What is wrong?

[upaliwije]

% incorrectly shown totaling not adding upto 100%

[sunny_talwar]

Which ones? can you point out?

[upaliwije]

Total Row Should be 100% and respective  % should be shown against each reason

[sunny_talwar]

May be you need this

if(RENEWED_PREMIUM=0 or (RENEWED_REFUNDS*1)=RENEWED_PREMIUM,SUM( RENEWABLE_PREMIUM))

/if(RENEWED_PREMIUM=0 or (RENEWED_REFUNDS*1)=RENEWED_PREMIUM,SUM(TOTAL<DEPT> RENEWABLE_PREMIUM))

[upaliwije]

Thanks Sunny

It is till not working. This is what I want

[sunny_talwar · Accepted solution]

May be this

Sum(if(RENEWED_PREMIUM = 0 or (RENEWED_REFUNDS*1) = RENEWED_PREMIUM, RENEWABLE_PREMIUM))

/Sum(TOTAL<DEPT> if(RENEWED_PREMIUM = 0 or (RENEWED_REFUNDS*1) = RENEWED_PREMIUM, RENEWABLE_PREMIUM))

[upaliwije]

Thanks Sunny

This is exactly what I want