Formula tool is not giving proper output even if the condition is met

[Sanjana_HS]

Hi can anyone help what is wrong with this formula why i am not getting proper result.

Formula used:if [Return Category]=[Categories] then [Rate Per Return] else "No rate" endif

Please find the excel where there is a rate for the highlighted columns but it is not flowing

[gautiergodard · Accepted solution]

Hello @Sanjana_HS 

Please see attached workflow.

Seems like your formula was working fine, perhaps it was the way your data was set up that was causing the formula to break.

If this answers your question, please accept this as solution :)

[Felipe_Ribeir0 · Accepted solution]

Hi @Sanjana_HS 

Please see if this gives you the expected result.

[Sanjana_HS]

I have one more doubt can you please help:

My input left anchor of joint tool has 219 records
My input Right anchor of joint tool has 18 records

So when I join it with common field it should give me  237 records but I am getting 822 records why?

[gautiergodard · Accepted solution]

@Sanjana_HS You must have duplicates of the same value coming from the left and right inputs of your join tool.

When these same values join on each other from both data sets it will create row explosion.

[Felipe_Ribeir0 · Accepted solution]

You said that the result should be 237 = 219 + 18?

The number of rows would sum like this with union operations, not joins.

If i understood well your problem, the result that you should expect is 219 rows. If the dataset is the same from the original post, check the sheet Rates Column Categories, this column probably have duplicated values and should not have.