Skip to Content
avatar image
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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    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

    Add comment
    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.

  • avatar image
    Former Member
    Jul 24, 2010 at 05:22 PM

    Thank's i solved by a virtual key figure.

    Add comment
    10|10000 characters needed characters exceeded