Hi,
Could someone please assist me in getting the edge summary for a percentage row to be calculated differently to other rows that is totalling (adding). Currently, my Gross Profit % row is adding at the total column (edge summary) instead of calculating the total percentage. I am using dimensional package.
I have attached a screen shot of the report output. Highlighted in yellow is the edge summary for "MTD Gross Profit %" which is totalling (adding) instead of calculating (total (MTD Gross Profit) / total ((MTD Sales)) 1706463/5285488 = 32.29%
Thank you
Change aggregate function property to Calculated of query item Gross Profit %
It's hard to tell what's going on with just a screen capture. Is the MTD Gross Profit % computed in the crosstab or in the query?
Can you reproduce the problem using the one of the sample databases? If so, a report spec would be helpful.
Quote from: HalfBloodPrince on 31 May 2016 01:56:37 AM
Change aggregate function property to Calculated of query item Gross Profit %
Thank you very much HalfBloodPrince. I changed the property to calculated and changed the solve order to 2 and it worked.