Member Dimension Formula If statement

[former_member269849]

Hello Experts,

Please I have a ratio KPI wich is the division of 2 loaded KPIs, But for budget the value should be inputed , How could I resolve that ? with an if statement?

regards.

[former_member186338 · Accepted solution]

You can't have the same member to be calculated by member formula and inputted! No way! Use different members.

Read:

https://blogs.sap.com/2013/02/21/average-percent-values-on-nodes/

[former_member269849]

Thank you Vadim.

[former_member186338]

In my sample look on:

Input member: PriceD

Calculated member used in the reports: PriceCalcD