XML mapping and formulas

(0) Share

Report

Posted on by Luca.l182u

Hello,

I am using XML mapping to create quotations from Dynamics.

What I want to do is, when I populate a table in the Word document, to make a math between different cells and show the result when the PDF of the quotation is printed.

I tried using bookmarks to the xml data and add a formula in Word like the example below, where quantity below "Prova" is a bookmark for Quantity:

It doesn't work, it seems the content of the cell E2 is always zero.

Do you have any suggestion?

Many thanks in advance.

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Yuri ji on at

Like (1)

Report

Hi Luca,

Unfortunately, after my testing, I also can't implement it.

I recommend that you can try to create a calculate column directly in the entity and add this field to the word template.

The steps I tested are listed below:

1. Create a calculate column.

2. Define rules.

3. Add this column to word template.

4. Export to PDF.

Was this reply helpful? Yes No
Luca.l182u 15 on at

Like (0)

Report

Many thanks for the answer!

I will test and let you know what I get.

Regards,

Luca

Was this reply helpful? Yes No