I have created a formula to calculate national insurance from gross pay, therefore if paid less than £105 then 0, else if paid over £105 then *0.128 to declare national insurance value per person - formula below
However, i need to subtotal the national insurance for each group that i have in the report (3) but if i sum(nationalinsurance, groupname) crystal tells me the filed cannot be summarised - HELP.....
//nationalinsurance
if (
{@gross pay person})>110
then (
{@gross pay person}-110)*0.128
else 0
IP Logged
