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

Question

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

Desktop.xlsx

gautiergodard · Accepted Answer

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 Answer

Hi @Sanjana_HS

Please see if this gives you the expected result.

gautiergodard · Accepted Answer

@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 Answer

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.