Share via

XML Mapping - Round up value

Anonymous
2023-08-28T17:22:50+00:00

Hi,

I have a field I'm retrieving from XML mapping pane. The XML pane is mapped to CRM 365. When I insert one of the field called "quantity", the value of the field comes back as "1.0000".

I was wondering if it was possible to round the value in work so it appears as "1" using a formula ?

Thank you

Microsoft 365 and Office | Word | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

3 answers

Sort by: Most helpful
  1. Anonymous
    2023-08-29T18:14:27+00:00

    Sorry for any type of implication but I did not mention using word. Remember that XML mapping itself doesn't perform any calculations, so this formula was for CRM 365.

    Regards,

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2023-08-28T18:14:47+00:00

    Hello Karim M! My name is Jeremy and I’m happy to help you with your question

    The formula below would round the number and get rid of the decimal and 0000.

    rounded_quantity = round(quantity)

    Thank you for reaching out to the users of this forum today.

    Regards,

    Was this answer helpful?

    0 comments No comments