crosstab displaying wrong percentage total

[saumil287]

Hi All,
I am having a xtab report containing Customers in rows.
YTD total for customers in columns, and YTD for each business unit showing percent of ytd.
The total of thier percentage displaying wrong.
I am using a built in func for calculating percentage ie Percentage (YTD)

Your guidance is appreciated
Thanks in advance
                           

[wyconian]

Hi

When you say the percentage isn't appearing correctly what do you mean exactly?  Can you give examples of how it is being displayed and what it should be?

Percentages can be a bit tricky.  Have you also formated the measure as a percentage?  If you use the standard calculation for a percentage (a/b)*100 and then format it as a percentage it will look wrong eg. if you have the calculation (10/100)*100 you'll get the answer 10, if you format that as a percentage you'll get 1000% (basically formatting a number as a percentage does part of the calculation for you).

If this is the issue you're seeing either change the calculation so it's just 10/100 (without the *100) and format as a percentage or keep the calculation as it is and don't format it as a percentage.

Good luck

[saumil287]

Hi wyconian,
The issue I am facing is that the total percentage of 4 bu to contribute 100% but it is not giving total of 100%

                                  A        B              C          D
            YTD               YTD       YTD       YTD     YTD
               
LG       3234543     15%    20%    44%    2%
Nokia  1256744     12%    39%     22%    3%

As shown above
A crosstab report
I want to calculate LG YTD% since the total for LG is 3234543, which is contributed by 4 BU A,B,C and D. When I calculate the % how each BU has contributed to LG, It should display the percentages which when totaled should be 100%.
but it is showing 81% when you calculate total of all percentage vaues corresponding to LG.

Your guidance is appreciated
Thanks in advance

[Anna S]

Hi
I don't know if I understood properly your problem, but I think you should try to do this:
modify the formula of the total. Instead of "total current measure within detail (...)", write "aggregate current measure within detalil (...)".
I hope this can help you.
Anna

[saumil287]

Hi All,
I got it, I used formula as Percentage(YTD for customer)
which gives me total of 100% for each customer
but another issue I am facing is that summary total of % of YTD and YTD ly is 200 %
I want 100% in the summary of YTD and YTD_LY

Thanks in advance

[Anna S]

Hi,
I got a similar error in the past. I had the amounts and the quantities and the prices calculated with a formula. For the single product the price was correct. For the total of products the price calculated was wrong. So I had to modify the formula of the total not the formula of the price. I think it could be similar to your problem: the percentage formula is ok, meanwhile the total formula has to be modified writing AGGREGATE instead of TOTAL.
Anna