Addition and Division Calculation

[#1]

Hi,

Can anyone please assist me on this.

I’m trying to add 2 amounts and then divide that by another but the number I get isn’t coming out right.

I have the Commission amount +  PiP  which is equal to total Income (3,347,518) and then I need to divide that by Volume (29,046)  to give me 115.

This is what I’m doing

sum({<[Month-Year] = {">=1<=5"}, [Month-Year] = {'Mar-2015'}, Date =, Week=>} Commission_Amount)+Sum ({<[Month-Year] = {">=1<=5"}, [Month-Year] = {'Mar-2015'}, Date =, Week=>} PIP_Profit_or_Loss) / sum({<[Month-Year] = {">=1<=5"}, [Month-Year] = {'Mar-2015'}, Date =, Week=>}, [Month-Year] = {'Mar-2015'}, Date =, Week=>} Volume)

But I’m getting 1,604,628

Thanks

Yolanda

[Anonymous · Accepted solution]

check the brackets properly

Use the whole brackets in the first and second calculation

[antoniotiman]

Hi Yolanda,

Try

(Sum(.......) + Sum(.......)) / Sum(.....)

Regards,

Antonio

[#4]

It Worked!!!

Thank you Antonio 🙂

[#5]

Got it, Thank you Jebmalai 🙂