Hi all,
I am struggling with the next problem, and hoping somebody can give me a little direction:
Trying to convert the next Excel sheet (example) to a SAS VA report (ListTable):
Next calculations are being done in Excel:
KPI = Sales/Plan (for example: =+C3/B3)
Weighting = Sales cell / Total of Sales (for example: =+C3/$C$9)
KPI Weighting = KPI cell * Weighting cell (for example: =+D3*E3)
Total is sum of row, except the column KPI. This is average:
In VA, Imported the data and created a list table:
All is working correctly:
Sum of sales is correct.
KPI avg is correct (gemiddelde = 81%)
Total of Weighting is correct. This should always be 1, if an customer filter is added for example, and a selection is made. (works fine)
But, the KPI weight is on cell level correct. But the total is incorrect. This should be 84% and not 406%
I know that he is doing in the background a calculation of a total of KPI * weighting = 406% * 1 = 406%.
But how can I change this? So the total of the column KPI Weight is not 406, but 84%
Tried several calculations (Table an Aggregated table options), but I am stuck on this issue.
Hope that someone can help me out.
Thanks in advance,
Daniël
... View more
