• Registered: 2018-12-12
  • Posts: 3

Topic: Operation on tablegrid value

Hi,

In my project I have two different TableGrid.
My goal is to substract the sum (footer) of one row in TableGrid1 with the sum of one row in TableGrid2.

I tried with calculated fields, but it does not upgrade when I add value in a TableGrid.

Do you have any idea ?

Post's attachments

Attachment icon afteradd.PNG 20.42 kb, 201 downloads since 2018-12-12 

2 Reply by derek (edited by derek 2018-12-12 17:59:48)

  • derek
  • derek
  • Moderator
  • Offline
  • Registered: 2015-02-16
  • Posts: 2,685

Re: Operation on tablegrid value

Hello Marcomvd,
Probably a number of ways but I think I would do it with a small script (see attachment) instead of a calculated field.
Hope this helps and please get back if anything is unclear.
Regards,
Derek.

Post's attachments

Attachment icon marcomvd.zip 338.59 kb, 331 downloads since 2018-12-12 

  • Registered: 2018-12-12
  • Posts: 3

Re: Operation on tablegrid value

Thanks a lot !

I did not see in the documentation that i can access "footer" and "formulavalue" of a particular column !

Regards

Marco