I am currently trying to use a percentage formula in a ReportNet report, which uses a cube. I have 5 columns in this report:
Product Year1Qty Year2Qty % of Year1 %of Year2
It is the last two columns which are causing me some grief. In the past, I would just use the formula percentage(X) and the percentage of column X would be generated. Now, the percentage which is being generated is based on both of the qty columns. I think it has something to do with the cube properties but I would appreciate any suggestions or tips.
Thanks!
i couldn't get percentage on both qty. Is that ur formulae is something like this (year1qty/(year1qty+year2qty) for % of year1 and similarly to % of year2
Srik
I don't understand your requirements. What are you trying to calculate as a % of Year1 and Year2? Please share the formula you're trying.
Sorry..I wasn't clearer..imagine the report to look like this:
Product Year1Qty Year2Qty Year1% Year2%
ProductA 1000 2000 .5 .5
ProductB 1000 2000 .5 .5
Total 2000 4000 1 1
The Percentage columns are describing what Product A represents to the Total, not the growth rate for one year to the next year.
In the past, I could use percentage(Year1Qty) and I would get the value.
Thanks!
Year1% = total(Year1Qty for [Product])/ total(Year1Qty for report)
Try this and let us know how it goes. Let me know if you have any questions.
Good luck.