Cannot get IN operator to work.

[Michael]

This expression does not work (it should).

=SUM(IIf(Fields.Grade In("07","08","09","18"), Fields.[Total Cost],0))

I can do individual SUM(IIf()) statements for each IS operator, but that is big and clunky. What am I doing wrong?

[Todor]

Hi Michael,

I tested the Expression in a custom report with a CsvDataSource with the indicated fields. It works correctly locally - see the linked silent video.

I have attached also my demo report for your reference.

If the problem persists you may open a support ticket and attach a runnable report (with sample data) for local investigation.

Regards,
Todor
Progress Telerik