|
Posted by J on May 29, 2008, 5:17 am
Please log in for more thread options 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:
> 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,
> >
> > 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:
> >
> > > 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,
| 
Yahoo! 
Google 
Windows Live 
del.icio.us 
digg 
Netscape 
XML Sitemap