Malformed function call error

if [Right_RecordID] = 8 then
if ToNumber([A]) = ToNumber([Row-1:A])+ToNumber([Row-6:A] AND ToNumber(TrimRight(ToString([A]),"%"))>=10 then "Pass"
elseif ToNumber([A]) = ToNumber([Row-1:A])+ToNumber([Row-6:A] and ToNumber(TrimRight(ToString([A]),"%"))<10 then "Threshold Breach"
elseif ToNumber([A]) != ToNumber([Row-1:A])+ToNumber([Row-6:A] and ToNumber(TrimRight(ToString([A]),"%"))>=10 then "Exception"
else "Threshold breach & Exception" ENDIF

when using the above formula in multi row formula I am getting the malformed function call error. In a column A. in row 8 the value needs to checked for2 conditions.

1. If it is greater than 10%

2. if it is a sum of row-1 and row-6

There are 4 conditions based on combinations

Data Investigation

Accepted answers

atcodedog05

Hi @hegdepavithra10

Another issue was Tonumber() bracket was not closed

atcodedog05

Hi @hegdepavithra10

I tried to do it with single tool. There were some issues. And lot of ToNumber() and ToString() function in sync.

Hence i went with this approach.

FYI Muti-Row formula is not that flexible for writing multiple nested formulas 😅

I am not saying its impossible its just not flexible since debugging is not easy😅

One issue i found was you need to use Trim([A],"%") everywhere you are using it which was missing. And rounding also does help.

And you were able to build a workflow that worked correctly thats amazing 🙂

All comments

atcodedog05

Hi @hegdepavithra10

It was missing the outer else and Endif

if [Right_RecordID] = 8 then
if ToNumber([A]) = ToNumber([Row-1:A])+ToNumber([Row-6:A] AND ToNumber(TrimRight(ToString([A]),"%"))>=10 then "Pass"
elseif ToNumber([A]) = ToNumber([Row-1:A])+ToNumber([Row-6:A] and ToNumber(TrimRight(ToString([A]),"%"))<10 then "Threshold Breach"
elseif ToNumber([A]) != ToNumber([Row-1:A])+ToNumber([Row-6:A] and ToNumber(TrimRight(ToString([A]),"%"))>=10 then "Exception"
else "Threshold breach & Exception" ENDIF
else Null() ENDIF