DP macro function : FIXCALC()

[Former Member]

Hi all,

Seeking the help of all APO gurus on the syntax for the function

FIXCALC().

I have already looked for help link below

http://help.sap.com/saphelp_scm2007/helpdata/en/8f/9d6937089c2556e10000009b38f889/frameset.htm

but unable to come up with the exact syntax of the function.

Can somebody help

Thanks in advance

[Former Member · Accepted solution]

Dear Ankur,

Quoting SAP Help:

FIX_CALC( X1; X2:

) performs fixing calculation with X1 as the row containing the key figure with the value to be fixed and X2 the key figure for the fixed values. If the input check indicator is set (for instance X), the system tries to correct any inconsistencies that may occur due to changes being made on the detail level.

For example, a key figure has a value of 100 at the aggregate level and consists of three values at detail level 50, 30 and 20. You then change the last value to 40, the system will reduce the remaining levels so that the total is still 100.

Macros using this function should not be used at detail level .

Regarding the exact syntax, let me give you this example with the same K-F to perform FIX, you can find this example at your 9AEXAMPLES View( MacroExamples) MacroBook

operate : ( 1,000 Iteraciones : 07.03.2005 ; 01.12.2007 )

calculate {activity bar}

FIX_CALC(

Línea: KF1 ( de 07.03.2005 )

Línea: KF1 ( de 07.03.2005 )

)

No comma or ";" would be necessary as far as it works without it.

Best regards,

Carlos Rodríguez

[Former Member · Accepted solution]

Hey Carlos,

Many thanks,

That reply solved my problem fully. All credit to your timely and exact response

Regards

Ankur