on 07-15-2009 11:57 AM
Hy experts, i create two calc. key figure, date1 and date2.These calc. key figure use two formula variable to take a value by rep. path from 0FDUEDAY and 0BLINE_DATE .
Then i create another calc. key figure, KF3 and KF4, that doing this operation's:
KF3 : (date1 - date2)* Billing Value
KF4: KF3/ Billing Value
So i have this problem that expose with this example:
Customer | date1 | date 2 | Billling | KF3 | KF4 |
A | 11.06.2009 | 11.06.2009 | 1000 | 0 | 0 |
B | 13.06.2009 | 11.06.2009 | 1000 | 2000 | 2 |
Result | X | X | 2000 | 2000 | X |
The problem is on the KF4's result: is possible to resolve the "X" value?
Thank's a lot.
Sincerely yours.
A. Maraviglia
Thank's i solved by a virtual key figure.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Andrea,
You probably use a Formula to calculate KF4. Use in this Formular the Data Function NOERR(X). This should solve the display issue.
Br
Joerg
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank's at all.
By a debug on rsrt, i find that the KF4's result is calculated as : ((date1_result - date2_result)*Billing Value) / Billing value.
So, the problem is on the result of date1 and date2.
Isn't possible to calculate the KF4's result as (KF3's result /Billing value's result)?
In this manner the result of KF4, in the example above, is 1.
Andrea
Hi,
For the Calculated Keyfigure KF4, in the properties make the settings to calculate result as Summation.
Otherwise, in the Enhance options, change the Time of Caluculation settings to either Before or After aggregation.
Veerendra.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi there,
Try in the query designer for the properties of KF4 in the tab Calculations change calculate result as Sum.
Diogo.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
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.