Forum Discussion

KG1's avatar
KG1
Icon for Resolver I rankResolver I
4 years ago
Solved

Rounding Issue ( I think)

Hi In my data the Orginal value and New AFP Value columns have a number of decimal places.  I used the rounding function to 2 decimal places, then I created a new custom column (Status) which says ...
Need Help
v-xiaotang's avatar
v-xiaotang
Icon for Community Support rankCommunity Support
4 years ago

Hi KG1 

Thanks for reaching out to us.

If you use the round() function instead of just adjusting the display format, the result should not be wrong.

Could you share the sample file? so that we can test it to find the reason.

 

Kindly note: You can replace the raw data with bogus data to protect your private information. Thanks 🙂

 

 

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

  • KG1's avatar
    KG1
    Icon for Resolver I rankResolver I
    4 years ago

    Hi

    I used the round.up fucntion and it fixed the problem

     

    Number.RoundUp([AFP Value],2)

     

    Thanks for your help