topic Re: NPrinting formulas in Power Point not calculated in Qlik NPrinting

NPrinting formulas in Power Point not calculated

pwagner — Fri, 12 Nov 2021 14:27:47 GMT

Hello all!

In our Power Point NPrinting report we us a formula to calculate the curent reporting date.

On 28 of 30 slides is will be calculated correctly:

On 2 of the 30 slides we do not get the date, instead we see <BusinessDate>

Do you have an idea how we can solve this issue?

Thank you.

Best regards, Patrick

Re: NPrinting formulas in Power Point not calculated

Ruggero_Piccoli — Fri, 12 Nov 2021 14:53:48 GMT

Hi,

Can you share the screenshots of the entire template?
Can you share the formula?
Are you using Pages to create different slides?
If yes, can you try to calculate the formula for the values of the field used in Pages that are not generating correct values of the formula? For example you can insert the formula in the source Qlik Sense app, apply the same filter of the report and check the result.

Best Regards,

Ruggero

Re: NPrinting formulas in Power Point not calculated

pwagner — Sat, 13 Nov 2021 06:25:01 GMT

We found the solution.

In the previous text was a "<" (... < 28 ... as af <BusinessDate>) and therefore the formula did not work.

We changed it to 1-28 and now the formula works.

Best regards, Patrick