Skip to Content
avatar image
Former Member

Aggregation exception doesnt work for summation in a CKF

Dear Experts , we have an issue in a report.

There are two RKF. 1. Agreed requirement 2.Constrained supply. This is a planning report and depends on forecast entered in the input screen, it displays value for 25 months.

In query design, Column has Calweek, Calmonth and Calyear. and hierarchially displayed through calweek.

In rows, all the formulas are defined. User requirement is to display agreed requirement value in 0-4 months and 5-24 should display constrained supply value.

I created this formula whereas Calmonth is formula variable with replacement path of 0CALMONTH and Forecast period is also Formula Var with replace path (of forecast entered in input) + 3. So, this logice works fine for 0-4 and 5-24 as per use requirement. However, I dont get the summation of month values to year. I tried exception aggregation (summation) ref charac as )calweek. Though, it doesnt work. In the year column it shows the Agreed requirement value.Am I missing anything? is there any other way to acheive this? pls help. Thanks in advance.

pic1.PNG (6.7 kB)
pic2.png (12.8 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Oct 29, 2015 at 06:18 PM

    Hi Joe,

    is the year column you show really the char 0CALYEAR or is it a node within the week-hierarchy?

    Becasue if it is a node, what you see there is considered as the result of your CKF.

    So go to your CKF, go to the properties - calculation.

    Set result calculation to "Summation".

    regards

    Cornelia

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 26, 2015 at 02:56 PM

    Hello Joe,

    You could try to use calmonth as reference characteristic instead of calweek since it is month not week in formula variable.

    BR

    Ondrej

    Add comment
    10|10000 characters needed characters exceeded