Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a formula for a title in a PowerPoint file in NPrinting and I'd like to know how I can edit it to be formatted a specific way. I have a variable named Year and the value looks like '2017'. I want my title to look like this:
FY17
My current formula is this: 'FY' & vYear
Can I edit the formula to just give me the last two digits or do I have to handle it elsewhere?
'FY' & right(vYear,2)
'FY' & right(vYear,2)
Perfect, thank you. Is there somewhere I can find the syntax I can use in editing formulas in NPrinting?
it should be the same syntax as in QlikView...