Skip to Content
0

Exception Aggregation for %age field

Jan 16 at 11:56 PM

78

avatar image
Former Member

Hi Experts,

I have a percentage field as a key field with another key field for amount. I have to build a report with MTD and YTD numbers. I need exception aggregation for %age key field. I tried the Average (values not equal to zero) but this one doesnt give me the expected numbers.

Has any one built a solution where he/she has used %age fields and defined any particular exception aggregation for it to work.

Regards

Bhawick

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Koen Hesters Jan 17 at 10:29 AM
0

Hi,

can you share some data examples, what you got and what you expect

thanks

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jan 17 at 06:15 PM
0

Time Sales Gross Sales %age

Period 1 20 100 0.20000

Period 2 15 50 0.30000

Period 2 YTD 35 150 0.23333 Expected numbers

0.25 This is what i am getting because i am using Average Exception Aggregation.

I have % age calculated with the data loads i just need to figure out how can i display the %ages in the report.

Regards

Bhawick

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Can you show how you build that all?

rows/columns ? restricted/calculated key figures ?

0
Loed Despuig Jan 26 at 09:43 AM
0

Hi,

Sorry I did not understand your report layout.

If this is your report layout, then RESULT should also compute based on the formula of your %age. I assume that the 3rd row is your RESULT row, right?

Period 1 20 100 0.20000

Period 2 15 50 0.30000

Period 2 YTD 35 150 0.23333

RESULT should also give you 0.23333 in the %age...

If it is showing an incorrect value, do this...

Click your %age field, choose SUMMATION in the EXCEPTION AGGREGATION tab and PERIOD as your REFERENCE CHARACTERISTIC...

Regards,

Loed

Share
10 |10000 characters needed characters left characters exceeded