Formula is giving wrong result

Hi Team,

As a very simple task, I have used below formula to populate value based on comparison of two columns. But, strangely, it is giving wrong result.

Formula is :- IF round([PV_REGFED],0)=round([PV_ZINC],0) THEN "Matched" ELSE "Not Matched" ENDIF

Manually I check that values between comparison columns are not matching but still above formula is giving result as "Matched".

Please let me know if I am missing anything.

Best Practices

Accepted answers

binu_acs

@Vikas038 not sure you can pass the "mult" parameter to "0" in the Round function, which will give you NULL values .

Please go through the post by @ChristineB , you will get better understanding of how round function works in Alteryx.

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-To-Round-Numeric-Values-with-the-Formula-Tool/ta-p/33683

binu_acs

@Vikas038 can you confirm below is that something you are looking for?

percentage.yxmd

All comments

Hamder83

Could you provide some sample data please?

binu_acs

@Vikas038 not sure you can pass the "mult" parameter to "0" in the Round function, which will give you NULL values .

Please go through the post by @ChristineB , you will get better understanding of how round function works in Alteryx.

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-To-Round-Numeric-Values-with-the-Formula-Tool/ta-p/33683

Hamder83

Maybe you could use round([PV_REGFED],0.25) ?

Vikas038

Thank you for the response as it worked. Although, in similar case, we are using formula ([PV_REGFED]-[PV_ZINC])/[PV_ZINC] to get percentage difference between two values in percentage format. This is also giving me incorrect result when I checked the same manually.

Can you please take a look into this?

Thank you

binu_acs

@Vikas038 can you provide some sample data and expected result ?

Vikas038

Value1	Value2	%age change(=(B13-C13)/C13)
80	100	-20%

binu_acs

@Vikas038 can you confirm below is that something you are looking for?

percentage.yxmd

Vikas038

Thank you team. This will work for me.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703