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.
Solved! Go to Solution.
Could you provide some sample data please?
@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.
Maybe you could use round([PV_REGFED],0.25) ?
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
@Vikas038 can you provide some sample data and expected result ?
Value1 | Value2 | %age change(=(B13-C13)/C13) |
80 | 100 | -20% |
Thank you team. This will work for me.