Monthly Sales Report - GP percentage calc not working

[lizzie]

Greetings!

I am really battling with a final calculation for one of my sales reports. The report I have created is a sub-summary report to analyse total sales, GP and GP Percentage per department of products sold (i.e. hardware vs software vs. consumables etc).

My report is great so far. I just cannot get the GP percentage calculation to be dynamic i.e. when I run the report over three months, my GP% calculates the entire GP Sum / Total of Recom extended. I have tried to do a sub-summary of GP Sum by Month and a sub-summary of Total of Recom extended by month and use these in a GetSummary calculation but the calculation fudges out.

Does anyone know how I can resolve this issue?

Do you require more information from me before being able to identify/diagnose the problem?

Edited December 8, 2007 by Guest

[Søren Dyhr]

Do you require more information from me before being able to identify/diagnose the problem?

This is too often the case, but perhaps is it enought to lead you these template:

http://www.databasepros.com/FMPro?-DB=resources.fp5&-lay=cgi&-format=list.html&-FIND=+&resource_id=DBPros000726

http://www.databasepros.com/FMPro?-DB=resources.fp5&-lay=cgi&-format=list.html&-FIND=+&resource_id=DBPros000752

--sd