This content has been marked as final.
Show 3 replies

1. Re: How to divide a sum(if sales type = A then [sales]end) / sum(if sales type = B then [sales]end)?
Deepak Rai May 1, 2018 12:58 PM (in response to Ava Kingsley)Hi Ava,
I just solved a similar today. Have a look here.
Calculating a value using the same column...
Thanks
Deepak

2. Re: How to divide a sum(if sales type = A then [sales]end) / sum(if sales type = B then [sales]end)?
Ava Kingsley May 1, 2018 1:14 PM (in response to Deepak Rai)Because my data is then broken down monthly, is it possible to get this calc to work each month? with the Fixed calc it shows the same value every month. I need it to change over time.

3. Re: How to divide a sum(if sales type = A then [sales]end) / sum(if sales type = B then [sales]end)?
Deepak Rai May 1, 2018 1:19 PM (in response to Ava Kingsley){Fixed DATETRUNC('month', [Date]): SUM(Same Thing from previous calculations)}