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) / count data less or equ...
Microsoft Dynamics NAV (Archived)

count data less or equal to a number in reports navision

(0) ShareShare
ReportReport
Posted on by Community Member

I have to count data that are less or equal to a number in one column and to count data that are greater than that number to another column. Any solution anybody?

 

<=80 >80
count data <=80 count data>80

 

*This post is locked for comments

I have the same question (0)
  • Verified answer
    keoma Profile Picture
    keoma 32,729 on at

    an example:

    You can also use the Sum function for conditional aggregate calculations. For example, if a dataset has a field that is named State with possible values Not Started, Started, Finished, the following expression, when placed in a group header, calculates the aggregate sum for only the value Finished:

    =Sum(IIF(Fields!State.Value = "Finished", 1, 0))

    follow for this link for details

    msdn.microsoft.com/.../ms157328(v=sql.120).aspx

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 50,245 Super User 2025 Season 2 on at

    Check this link

    community.dynamics.com/.../nav-report-how-to-use-excel-sumif-function

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)

#1
HoangNam Profile Picture

HoangNam 7

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans