Notifications
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
OussamaSabbouh 3,177
Jainam M. Kothari 2,467 Super User 2025 Season 2
YUN ZHU 1,435 Super User 2025 Season 2
