on 10-23-2015 8:42 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ondrej,
Thanks so much. I tried this option already. but report was throwing error. but got a notes regarding RP variables. so i used attribute instead of Key for Calmonth replacement variable . And in summation i changed reference field as 0calmonth. now it worked like magic.. thank you so much for your time
User | Count |
---|---|
87 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.