Report with Percent of Total

Hi Eugen,

Use a custom field on the report and do it as a calculation like this

Begin Column FieldName = "Pecent" DrillDownFieldName = "" DrillDownReportName = "" StoreIDFieldName = "" Title = "% Margin" VBDataType = vbDouble Formula = "(ITEM.PRICE-ITEM.COST)/(ITEM.PRICE+0.0000000001)" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 780 GroupMethod = groupmethodAverage ColFormat = "#.##%" End Column

Hope that helps?

"Eugen" wrote:

Thanks J,

thay want something like the following:

DEPARTMENT SALES PERCENT total $100.00 WINE $10.00 10% BEER $90.00 90%

I'm guessing the formula would be something like (QUANITY * PRICE)/SUM(QUANTITY*PRICE).

"J" wrote:

Hi Eugen,

That looks right to me, try it and see what happens, you can always remove it later if all goes wrong ;-)

Alternativley for advance calculations and data presentation we create views in the SQL Enterpise Manager - we find allows for higher level data analysis. The tell the RMS reporter to use thed view instead of the default tables.

If that makes sense?

"Eugen" wrote: