Converting Excel Formula to Alteryx Language

quims

Hi Alteryx Community,

I have another question about formula as I'm planning to migrate my working file to Alteryx but have some difficulties in converting these formula to Alteryx.

My current formula is as follow. See attached file.

Formula 1: =IF(SUMPRODUCT(($A$2:$A$99997=A2)*($E$2:$E$99997))<B2,"15",IF(SUMPRODUCT(($A$2:$A$99997=A2)*($F$2:$F$99997))<B2,"45",IF(SUMPRODUCT(($A$2:$A$99997=A2)*($G$2:$G$99997))<B2,"75")))

Formula 2: =IF(SUMPRODUCT(($A$2:$A$99998=A2)*($E$2:$E$99998))<B2,"15",IF(SUMPRODUCT(($A$2:$A$99998=A2)*($F$2:$F$99998))<B2,"45",IF(SUMPRODUCT(($A$2:$A$99998=B2)*($G$2:$G$99998))<B2,"75")))

Thanks in advance.

Atleryx Formula.xlsx

RolandSchubert

There is a function available to subtract days from a specific date. As the result field may also contain a string (Check CR/DR), a bit of conversion is needed. See attached workflow,hope it returns the result you expect.

DateAdd.yxmd