Calculated Key Figure and Formula Variable

[Former Member]

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

[Former Member]

Thank's i solved by a virtual key figure.

[Former Member]

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

[Former Member]

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

[Former Member]

Hi,

You can use data functions in formulas like result and over all result.

Reg

Pra

[Former Member]

Hi there,

Isn't possible to calculate the KF4's result as (KF3's result /Billing value's result)?

Yes it is, and it's the best approach!

In this manner the result of KF4, in the example above, is 1.

Yes indeed!.

Diogo.

[Former Member]

Hy Diogo, how i can doing this?

[Former Member]

Sorry,

I thought you had said calculation of KF4, and not the calculation of KF4 result

Diogo.

[Former Member]

My problem is about the KF4 result.

[Former Member]

Hi there,

Did you tried in the query designer for the properties of KF4 in the tab Calculations change calculate result as Sum?

Diogo.

[Former Member]

If i change the calculation of Result as Total i don't obtain a correct result beacasue isn't the same of [KF3's result /Billing value's result].

A virtual key figure , could be a solution?

Thank's a lot.

[Former Member]

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.

[Former Member]

Hi there,

Try in the query designer for the properties of KF4 in the tab Calculations change calculate result as Sum.

Diogo.