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 community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
OussamaSabbouh 545 Super User 2026 Season 2
YUN ZHU 354 Super User 2026 Season 2
Grigorios Mavrogeorgis 228 Super User 2026 Season 2