Cannot get IN operator to work.
1 Answer 13 Views
Michael
Top achievements
Rank 1
Michael asked on 03 May 2021, 08:51 PM

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?

1 Answer, 1 is accepted

Sort by
0
Todor
Telerik team
answered on 06 May 2021, 12:40 PM

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

Тhe web is about to get a bit better! 

The Progress Hack-For-Good Challenge has started. Learn how to enter and make the web a worthier place: https://progress-worthyweb.devpost.com.

Asked by
Michael
Top achievements
Rank 1
Answers by
Todor
Telerik team
Share this question
or