how to use calculated value in footer section

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…



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…:slight_smile: