calculation of field

shwetashweta Member Posts: 94
I have fields rate amount and quantity and at table level i want to calculate amount as rate*quantity how i can do it

Comments

  • ar4ijsar4ijs Member Posts: 24
    When do you need calculation to be done ?
    You can't do it automatically like flowfield, you must code somewhere.
  • shwetashweta Member Posts: 94
    ar4ijs wrote:
    When do you need calculation to be done ?
    You can't do it automatically like flowfield, you must code somewhere.

    where i can write this code
  • AlbertvhAlbertvh Member Posts: 516
    Hi
    You could do it in the OnValidate of both the fields
    Amount := Rate * Quantity;
  • shwetashweta Member Posts: 94
    Albertvh wrote:
    Hi
    You could do it in the OnValidate of both the fields
    Amount := Rate * Quantity;

    thanks i got solution
Sign In or Register to comment.