web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / FIELD based filter in ...
Microsoft Dynamics NAV (Archived)

FIELD based filter in FlowField (Dates)

(0) ShareShare
ReportReport
Posted on by Ghetz 3,013

So I have a table with 3 fields:

- Start Date

- End Date

- Amount (FlowField)

I would like the Amount flowfield to be "SUM(Amount) from "Sales Lines" where "Posting Date" between "Start Date" and "End Date"

I would like to enable a Page so a user can create entries in this table, and on the spot be able to see the Amount.

Seems like when setting FILTER in a flowfield's definition, you cannot use field names. 

Also when using FIELD, we cannot user formulas

Any workarounds to achieve this??

*This post is locked for comments

I have the same question (0)
  • Suresh Kulla Profile Picture
    Suresh Kulla 50,243 Super User 2025 Season 2 on at

    Create a FlowFilter of Type Date and use that filtering, for example: check the currency table and look at the formulae for Customer Balance, Vendor Balance...

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.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans