How to replicate the excel formula =IF(R12=R11,0,IFNA(SQRT(VLOOKUP(R12,R:T,2,0) in alteryx

[Inactive User]

Columns : R,S,T

R= Hegde

S= Sum1

T= Sum2

Please help

[IraWatt]

Hey @Inactive User,

Can you give an example excel sheet you want to replicate in Alteryx?

Thanks,

Ira

[Inactive User]

@IraWatt  Please go through the below excel sheet and help me on how to replicate the formula in alteryx

[IraWatt]

Hey @Inactive User,

To replicate this function you will need to use a multirow formula to compare different rows. To achieve this F3=F2 then zero this formula will work:

IF [Hedge]=[Row-1:Hedge] THEN 0 ELSE ....

Square root can be found in the Alteryx Maths functions:

The Vlookups are hard for me to understand as you have only given 1 line of data. 

[Inactive User]

Here are the few formulas in the excel which needs to be replicated in alteryx.. Please help me. 

[binuacs · Accepted solution]

@Inactive User one way of doing this 

[Inactive User]

Thank you so much team,