Announcements
No record found.
Hi:
Does anyone have a list of basic formulas used for Jet Reports, such as ".." representing a range?
Thanks!
John
I believe they are the same as the business central ones.
All listed about halfway down, I'll have a look when next on my laptop as I have a cheat sheet for this.
docs.microsoft.com/.../ui-enter-date-ranges
Thanks, Paul!
One thing in particular that I'm looking at is a formula specifying a range of account numbers and excluding one of the account numbers in that range.
You would use the pipe key
In this example all records from 1000 to 2000 and (pipe is just and) 2002 to 3000 missing 2001
1000..2000|2002..3000
Great! Thank you, Renni! This is much appreciated!
If you have a cheat sheet that you could send later on, that would be great. :)
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
OussamaSabbouh 1,965 Super User 2026 Season 1
YUN ZHU 1,125 Super User 2026 Season 1
Dhiren Nagar 961 Super User 2026 Season 1