Hi, i’m using dynamcs ax 2009. in my report i have 3 fields ; say, Balance, Value & Ratio.
i have designed using autodesign. My problem is, i get the grand total of Balance, Value. but in the ratio field i need to use a formula like — the grand total of balance -Value/ balance * 100
How can i do that? Pls help
Hi annjames,
Use Programmable section…execute after while loop…thats it…
regards,
sandesh
Declare a variable in class declaration.
in the same method where you are getting the grand total, calculate the value by using your formula and store it into that variable which you have declared in class declaration and just return that variable in your footer control’s display methos.
it may helps you…