1. Home
  2. Point-Of-Sale Software
  3. Report with Percent of Total

Report with Percent of Total

Hello,

Is it possible with the report writer to create a field which is a percentage of the total. For example on the value list we can have a total field. My customer wants another field on the report which is a percentage value of the total.

Thanks,

Reply to
Eugen
Loading thread data ...

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:

Reply to
J

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:

Reply to
Eugen

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?

J

"Eugen" wrote:

Reply to
J

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.