Former Member

### Calculated Key Figure and Formula Variable

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

10|10000 characters needed characters exceeded

• Former Member
Jul 15, 2009 at 11:01 AM

Hi there,

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

Diogo.

10|10000 characters needed characters exceeded
• Former Member
Jul 15, 2009 at 11:07 AM

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.

10|10000 characters needed characters exceeded
• Former Member
Jul 15, 2009 at 11:14 AM

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

10|10000 characters needed characters exceeded
• Former Member 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
Jul 24, 2010 at 05:22 PM

Thank's i solved by a virtual key figure.