Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
check the brackets properly
Use the whole brackets in the first and second calculation
check the brackets properly
Use the whole brackets in the first and second calculation
Hi Yolanda,
Try
(Sum(.......) + Sum(.......)) / Sum(.....)
Regards,
Antonio
It Worked!!!
Thank you Antonio 🙂
Got it, Thank you Jebmalai 🙂