Calculated field on GRID

Developers Programming
#1

Hi Everyone!

I have created a field in the Grid applications named qty in stock.

1.) Can I do a calculation on “onrecord”?

2.) qty in stock = qty on hand - sum (item issued) - sum (item returned) for specific item
How can I do this formula?

Regards

#2

Re: Calculated field on GRID

Create a new user defined field using ‘New Field’

Use onRecord to update:

{calc_field} = {qty_field} - ‘the rest of your formula’

Regards,
Scott.

1 Like