Hi Karen,
You shouldn't need to use the sum formula, you can just use a calculation in the conditional text(https://help.nintex.com/en-US/docgen/docservices/#docgen-sfdc/Services/templates/ConditionalTextWord.htm). It would look like the following:
- {=<<Event_Fiscal_Year>>-1954}
I tried removing the word "SUM" from my formula and I am still not getting any output. Here are all of the ways I've tried it and none of them produce a result in the DDP document:
{="<<Attendee_Fiscal_Year>>"-1950}
{="<<Attendee_Fiscal_Year>>",-1950}
{=<<Attendee_Fiscal_Year>>-1950}
{=<<Attendee_Fiscal_Year>>,-1950}
{=SUM("<<Attendee_Fiscal_Year>>"-1950)}
{=SUM("<<Attendee_Fiscal_Year>>",-1950)}
{=SUM(<<Attendee_Fiscal_Year>>-1950)}
{=SUM(<<Attendee_Fiscal_Year>>,-1950)}
I am putting this in a word formula field.
Hi Karen,
In my testing the one I provided was working. If you provide the template I can have a quick look. Alternatively you could log a support case and they might be able to help with why it is not populating.
how to add two field tagger value using sum function in Drawloop