I'm running the NAV073 - Vendor Payments History report.
The Slicer is showing every day from the posting date.
I'd like it to group by month on the posting date but still see the date in the table.
I've tried a Calculated field but that failed when the grouping was applied.
I tried to bring the posting date into the report twice using a different column name but it wouldn't show the date twice.
Has anyone managed to duplicate a field for slicing before?
Regards Chris
Date
Votes
5 comments
-
Jet Reports Historic Posts Here is a copy of the report with an added column and slicer for you to use for further development.
-
Jet Reports Historic Posts Hi Joel,
It's taken a while but I've finally got round to writing all my KPI reports.
Thanks for listing this report although on the first try I couldn't get it to work.
I think it has to do with…
=NP("Formula","=Month([@[Posting Date]])")
which is causing an error.
Have you any ideas what it could be? -
Jet Reports Historic Posts Hello Chris,
All Jet reports are built on the current versions available at the time they are designed.
If you are using an older version of Excel you will want to use [[#ThisRow],[Posting Date]] syntax instead.
I believe this is Excel 2007 syntax, and 2010 has the @ syntax.
Regards, -
Jet Reports Historic Posts Hi Joel,
I'm on 2010 and even tried the other version without any luck.
Could it be the =NP as I don't recognise it? -
Jet Reports Historic Posts Hello Chris,
Sorry, you are correct, The NP function is in Essentials not Express.
The report was designed for use in Essentials.
Regards,
Please sign in to leave a comment.