Totals with condition

[Worm]

I need your help. Is it possible to calculate totals with condition?

[Edward]

Is it possible to calculate totals with condition?

StimulReport.Net allows to add a condition to an aggregate function. When you add a condition to an aggregate function you should add If to this aggregate function name and additional argument with condition. For example:

Code: Select all

{SumIf(Products.UnitsInStock, Products.UnitsInStock > 0)}

this expression will return the sum of elements but every element is to be higher than zero. For the Count function:

Code: Select all

{CountIf(Products.UnitsInStock == 0)}