What is the use of Maximum Hotspots and solve Order in RS
Quote from: krishdw85 on 28 Sep 2015 07:16:37 AM
What is the use of Maximum Hotspots and solve Order in RS
http://public.dhe.ibm.com/software/data/cognos/documentation/docs/en/10.2.2/ug_cr_rptstd.pdf
1. Page 936
2. Page 976
https://qmetrix.com.au/cognos-using-the-solve-order-feature-in-report-studio/
12.6? how? did nt get it....
Quote from: krishdw85 on 28 Sep 2015 07:50:36 AM
https://qmetrix.com.au/cognos-using-the-solve-order-feature-in-report-studio/
12.6? how? did nt get it....
What don't you get? You can see the initial issue where the percentages for the rows are being calculated, then these percentages are being totalled for the overall GM% figure - which is incorrect. The article states
QuoteWe want report studio to calculate the GM% after totalling the Revenue and GM columns
- in other words to calculate the percentage based on the totals for Revenue and GM. This means it has to be calculated after these totals have been produced. Solve Order allows you to define in what order calculations are performed. The RS User guide tells you this
QuoteThe item with the lowest solve order value is calculated first, followed by the next lowest value, and so on.
Can you be specific about which part you don't understand?
MF.
Thx MF.
Sorry i did not understood how the total seems 12.6.can you please explain clearly what all the numbers it is calculated to get 12.6
(674,861 / 5342771) * 100 = 12.6%
Yeah... Thanks mite!