How do you multiply two numbers in Appsheet?

[FTong]

Newbee here...  (May sound silly, but it is driving me up the walls... lol) 

Description: 

Table 1 - holds the constant rate of change of a "chemical" reaction. There are 3 standard values for each type of reaction (Item_Rate = RateA, RateB, and RateC). (The values have 3 decimal places and range from 1.000 to 15000.000)

Table 2 - is a form used to input the quantities  tested (Item_Qty) and the selected Reaction type (along with dates, technician name, etc..) (the quantities values range from 1.000 to 1000.000)

In Table #2, I can get the correct value of Item_Rate from Table 1 using a Select() function as Suggested Value. 

(NOTE: I am using Suggeste Value for the calculations because the constant some times need to be nodged a little if weather was too cold during the test). 

Column Type = Decimal for both columns ( Item_Qty and Item_Rate)

I am trying to set a third column (Item_Amount) to multiply the two values but I keep getting Zero as a result when I use: 

[_thisrow].[Item_Qty] * [_thisrow].[Item_Rate]

Question: 

Is there a proper way to multiply two decimal values? 

What is the correct format to multiply two numbers 

[TeeSee1]

Try not using [_THISROW]

You are simply performing calculation between columns of the same row. 

[FTong]

TeeSee1, 

Thank you for your prompt response.  

I tried [Item_Amount]*[Item_Qty] and still get zero for answer... 

I also check that the columns are set to Type Decimal. 

Any ideas? 

[latetoparty]

You want to [Item_Qty]*[Item_Cost] to work out [Item_Amount]. 

You are writing a function in the box you want to function on. It wont work. 

[TeeSee1]

Item Amount values seem all ZEROS...

[TeeSee1]

This is very strait forward...

You have correctly set your mins, decimal digits, etc..., right?

[Marc_Dillon]

Do you understand the difference between when App Formulas evaluate, in real columns versus virtual columns?