topic Re: NPrinting Formula Help in Qlik NPrinting

NPrinting Formula Help

mikecrengland — Wed, 11 May 2016 22:12:01 GMT

Hello All -

I have an NPrinting issue that's driving me crazy.

In all of my Excel reports, I create a formula to give the date of the report:

='As of ' & Date(today(),'M/D/YY')

It's always worked until today. This time, it simply displays as the tag:

The formula above it is similar: ='For the week of ' & Date(Cal.WeekStartMon,'M/D/YY') and it works. The number format on both cells is 'General'.

Any ideas what the heck is happening?

Thanks!

mike

Re: NPrinting Formula Help

Anonymous — Thu, 12 May 2016 11:25:25 GMT

Does it give you the same result if you put your formula in a different cell in your template?

Excel is very peculiar. I can't tell you the number of times I have written formulas in Excel only to learn that the cell was formatted as text. You have text in the two cells above it, so perhaps that is your answer.

Re: NPrinting Formula Help

mikecrengland — Thu, 12 May 2016 13:48:43 GMT

That worked... Thank you!!