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