Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

replicate excel formulas in alteryx

Inactive User
Not applicable

Sheet 1: =IF(F10=F9,0,MIN(0.05+0.95*EXP((H10-I10)/(2*0.95*G10)),1))

Sheet 2: =IF(F15=F14,0,MAX(G15-H15,0,(I15+J15-K15)))

Sheet 3: =IF(F20=F19,0,IF(G20="N",Sheet1!F12,IF(J20<0,MAX(K20-L20+M20,0),MAX(N20-O20,0))))

 

Hi, team please help me to replicate these excel formulas in alteryx. Thanks in advance

10 REPLIES 10
Inactive User
Not applicable

Please help 

grazitti_sapna
17 - Castor

Hello @Inactive User , I am able to replicate the first 2 formulas but the 3rd formula cannot be directly implemented as it involves lookup also in the lookup it is mentioned that you need Row F12 from sheet one but there is no value so can we assume that it is null by default or 0?

Can you please elaborate on the 3rd formula which you are trying to implement in sheet 3?

 

Thanks!

Sapna Gupta
Inactive User
Not applicable

My bad, I will be right back

The formula is =IF(F20=F19,0,IF(G20="N",MAX(F12,IF(J20<0,MAX(K20-L20+M20,0),MAX(N20-O20,0)))))

Inactive User
Not applicable
grazitti_sapna
17 - Castor

@Inactive User, in this formula 

=IF(F20=F19,0,IF(G20="N",MAX(F12,IF(J20<0,MAX(K20-L20+M20,0),MAX(N20-O20,0)))))

What would be the value of F12 as for now in the sheet F12 is empty

grazitti_sapna_0-1654671458965.png

 

 

Sapna Gupta
Inactive User
Not applicable

I am extremely sorry for that. It is taking automatically. 

Here is the updated formula: =IF(F20=F19,0,IF(G20="N",MAX(H20-I20),IF(J20<0,MAX(K20-L20+M20,0),MAX(N20-O20,0))))

grazitti_sapna
17 - Castor

Hi @Inactive User, give this a try and let us know if it works for you?

I hope it works!

 

Thanks!

Sapna Gupta
fsalmon
7 - Meteor

Hi Thatiparti,

 

I believe what you're looking for is the multi-row formula tool. This lets you refer to previous rows in your calculations.

 

fsalmon_0-1654672586799.png

 

fsalmon_1-1654672681067.png

 

Inactive User
Not applicable

Thank you so much @grazitti_sapna 

Labels