Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Multi-Row Formula help

crtakacs
8 - Asteroid

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. 

 

crtakacs_0-1610636516802.png

 

crtakacs_1-1610636543114.png

 

2 REPLIES 2
Kenda
16 - Nebula
16 - Nebula

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
8 - Asteroid

That worked - thanks! 

Labels
Top Solution Authors