Client request – In the model, we have the elements Quantity, Price, and Net Sales. Quantity and Price are input fields, and there is a rule on Net Sales: Quantity × Price = Net Sales.
The client wants the ability to keep Price fixed and to be able to modify both Quantity and Net Sales at both N and C levels. They do not want any workarounds or additional measures or elements.
Can someone help with this? Thank you in advance.

Tina

Client request – In the model, we have the elements Quantity, Price, and Net Sales. Quantity and Price are input fields, and there is a rule on Net Sales: Quantity × Price = Net Sales.
The client wants the ability to keep Price fixed and to be able to modify both Quantity and Net Sales at both N and C levels. They do not want any workarounds or additional measures or elements.
Can someone help with this? Thank you in advance.

Tina

Hi Tina

With a rule like ['net sales'] = N: ['Quantity'] * ['Price'];

You can hold net sales et input value into Quantity or Price

You can hold Quantity and "spread data" into Net Sales

You can ( i hope, play with N and C level).

I write a wiki (in franche sorry) wich explain all you can do with this kind of solution : https://www.next-decision.fr/wiki/utilisation-des-consolidations-dans-planning-analytics

Hope it can help.

Kind regrds,

Philippe

Client request – In the model, we have the elements Quantity, Price, and Net Sales. Quantity and Price are input fields, and there is a rule on Net Sales: Quantity × Price = Net Sales.
The client wants the ability to keep Price fixed and to be able to modify both Quantity and Net Sales at both N and C levels. They do not want any workarounds or additional measures or elements.
Can someone help with this? Thank you in advance.

Tina

Client request – In the model, we have the elements Quantity, Price, and Net Sales. Quantity and Price are input fields, and there is a rule on Net Sales: Quantity × Price = Net Sales.
The client wants the ability to keep Price fixed and to be able to modify both Quantity and Net Sales at both N and C levels. They do not want any workarounds or additional measures or elements.
Can someone help with this? Thank you in advance.

Tina

Client request – In the model, we have the elements Quantity, Price, and Net Sales. Quantity and Price are input fields, and there is a rule on Net Sales: Quantity × Price = Net Sales.
The client wants the ability to keep Price fixed and to be able to modify both Quantity and Net Sales at both N and C levels. They do not want any workarounds or additional measures or elements.
Can someone help with this? Thank you in advance.

Tina