Hi, I have a SS formula question. I am using summary type SUM to calculate the sum of all new sale over amounts and I want to set a formula on that sum. I basically need to calculate a commission, the %tage of which depends on the new sales ranges (e.g. CASE WHEN {Total Sales} < 100 then 5%*{total Sales} ELSE 10% *{Total Sales} END). Is there anyway to calculate such a formula on the NS totals or replicate the Total Sales in a formula?