Hi, I have a cross tab gross profit report, it looks like the below:
MTD Actual MTD Budget MTD Variance
Gross Sales (A) 100 80 20
Cost of Good Sold (B) 70 60 10
GP= A - B 30 20 10
GP% = GP/A 30% 25% 50% (error)
The problem is GP% in 'MTD Variance' column is calculated as 10/20 = 50% (GP/Gross Sales) instead of 30% - 25%. Basically I need column calculation (MTD Variance) to overwrite row calculation (GP%). How can I achieve this?
Many thanks
Quote from: Sean on 06 Nov 2014 12:21:39 AM
Hi, I have a cross tab gross profit report, it looks like the below:
MTD Actual MTD Budget MTD Variance
Gross Sales (A) 100 80 20
Cost of Good Sold (B) 70 60 10
GP= A - B 30 20 10
GP% = GP/A 30% 25% 50% (error)
The problem is GP% in 'MTD Variance' column is calculated as 10/20 = 50% (GP/Gross Sales) instead of 30% - 25%. Basically I need column calculation (MTD Variance) to overwrite row calculation (GP%). How can I achieve this?
Many thanks
Try selecting the GP% calculation and setting its Solve Order property to 2
Cheers!
MF.
Thank you very much Champion.
Sean