Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Use below expression for Rate
sum(TOTAL [ZBudget_Budget Rate]* ExchangeRate*BudgetQty)/sum(TOTAL BudgetQty)
not sure if I completely understood but I believe you want something like the attached document
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.
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
Use below expression for Rate
sum(TOTAL [ZBudget_Budget Rate]* ExchangeRate*BudgetQty)/sum(TOTAL BudgetQty)
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
sum(TOTAL {<[ZBudget_Material Code]>}[ZBudget_Budget Rate]* ExchangeRate*BudgetQty)/sum(TOTAL {<[ZBudget_Material Code]>}BudgetQty)