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.

need formula

45134904
7 - Meteor

No. of Past Due Days Movement – DPD increase of accounts reported in current month from previous month is only 30 days
Field: OHCACCT
NumberofDays
Error: If previous month NumberofDays = 000 and current month NumberofDays > 001
If previous month NumberofDays = 001 and current month NumberofDays > 030
If previous month NumberofDays = 030 and current month NumberofDays > 060
If previous month NumberofDays = 060 and current month NumberofDays > 090
If previous month NumberofDays = 090 and current month NumberofDays > 120
If previous month NumberofDays = 120 and current month NumberofDays > 150
If previous month NumberofDays = 150 and current month NumberofDays > 180

1 REPLY 1
PhilipMannering
16 - Nebula
16 - Nebula

Can you provide some sample data and the expected output? This would help understand what you're trying to do.

Labels
Top Solution Authors