Logic Help

[abhaysingh]

Hi Guys,

Please find the Sample data

In the data u will see

Product Group      |          Material Code          | Budget Qty          | BUdget Rate          | Exchange Rate    

Against one work group as per data A6000 there are two material code, there Qty , Rate and Exchane Rate

Final Value is calculated by logic

sum([ZBudget_Budget Rate]* ExchangeRate*BudgetQty)

after calculating Budget Rate there is One rate comes, let say 22.91, but i want when i select material code against the product group that value 22.91 will not change.

Right now when i m doing it it is changing.

pls suggest

[ramoncova06]

not sure if I completely understood but I believe you want something like the attached document

[MK_QSL]

Don't understood your question properly. but try below one..

sum({<[Material Code]=>}[ZBudget_Budget Rate]* ExchangeRate*BudgetQty)

Instead of 22.91 if you mention the exact amount as per your sample data, it will be easy to answer.

[abhaysingh]

Hi Guys,

Pls find the attached sample, in this you will se against one material grp rate is 41.88 and for other 22.47,

and total rate is 22.91,

instead of rate 41.88 and for other 22.47, i want 22.91 for all material.

Hope i m clear with what i want

thanks

[MK_QSL · Accepted solution]

Use below expression for Rate

sum(TOTAL [ZBudget_Budget Rate]* ExchangeRate*BudgetQty)/sum(TOTAL BudgetQty)

[abhaysingh]

Hi Manish,

One more thing want to ask, when i select any single material code, than Rate changes from 22.91 to their respective calculative value 41.88 or 22.47..

can we do it like , even we select particular material even than their Rate remain 22.91?

thanks

[MK_QSL]

sum(TOTAL {<[ZBudget_Material Code]>}[ZBudget_Budget Rate]* ExchangeRate*BudgetQty)/sum(TOTAL {<[ZBudget_Material Code]>}BudgetQty)