2 Replies Latest reply on Nov 18, 2016 1:46 PM by Rekha Kesavan

# Find sum of remainders and add to last row

Hello,

I need some help with a calculation where I need to add the remainders of some categories to the value of another category. Like in the table below, I need to round down a 12% allocation for Type A, B, And C. Then add the sum of those remainders to the allocation of Type D. Basically, I'm trying to end up with the numbers in my "Final Calc" column.

 Catergory Count 12% of Count Remainder (Found w/Modulo) Final Calc Type A 20 2.4 0.4 2 Type B 35 4.2 0.2 4 Type C 15 1.8 0.8 1 Type D 30 3.6 0.6 5(3.6+0.4+0.2+0.8)

I've tried making some If/Then statements, but having a hard time. Any suggestions?

Thanks!

Aubrey

• ###### 1. Re: Find sum of remainders and add to last row

Aubrey,

Have you tried Table calculations yet?

go to the measure you want to use

within the pill, click the little carrot and select the table calculation you'd like to use.

If you attach the workbook we could try and help you as well,

Best,

--Matt

• ###### 2. Re: Find sum of remainders and add to last row

Hello Aubrey,

You can try using the TOTAL() in your calculation.