Multiply 2 fields to show in a seperate field.

Applications Grid / Reports
#1

Hi!

I tried to multiply ‘price’ and ‘quantity’ field to appear in the ‘total’ field in the grid but since i have price_id from other table in the current table as ‘price’ , ‘quantity’ just multiplies with the id. How is this done the right way?

Example:

CURRENT TABLE

Price Quantity

1 3
3 1.25

want to multiply Price * Quantity as ‘total’ but since Price is ID from table called price its just multiplying with the ID to give wrong results. Have used lookup values in the grid and in the grid, Price shows right, just not in the total field.

Thanks!

#2

Re: Multiply 2 fields to show in a seperate field.

Figured it out by myself. Thanks all anyway.