Replicate excel formula

[Inactive User]

Hi team, please help me to replicate the excel formula in alteryx. Thanks in advance

 =IF(F6=F5,0,G6/H6)

[binu_acs · Accepted solution]

@Inactive User @This can be achieved by using the multirow formula tool

in the multirow formula tool add the below formula and select the field type as double 

IIF([Row-1:R] == [R], 0, [S]/[T])

[Inactive User · Accepted solution]

Thanks much @binu_acs 

[Inactive User]

@binu_acs The output is coming as1 but it is in decimals 0.7855. please help

[IraWatt]

@Inactive User Makes sure the output is of type double