count data less or equal to a number in reports navision

(0) Share

Report

Posted on by Community Member Microsoft Employee

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

All responses (2)

Answers (1)

Suggested answer

Suresh Kulla 43,745 on at

Like (0)

Report

RE: count data less or equal to a number in reports navision

Check this link

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

keoma 32,675 on at

Like (0)

Report

RE: count data less or equal to a number in reports navision

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