ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
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