Multi-Row Formula help

[crtakacs]

Could someone help explain what I'm doing wrong to not get values where there are zeros in the Field 2 column? I'm trying to find the difference between price values when the PURITY_PROD_CD = PURITY_PROD_CD from the previous row. So I'd expect Row 2 Field 2 to equal 0.00125, Row 4 Field 2 to equal 0.02125 and so on. 

[Kenda · Accepted solution]

Hey @crtakacs 

It looks like the new field you created is an Int field which cannot handle decimal places. Try changing this to a double. 

[crtakacs]

That worked - thanks!