This is a migrated thread and some comments may be shown as answers.

Iff Function error?

1 Answer 52 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
akpaga akpaga
Top achievements
Rank 1
akpaga akpaga asked on 30 Apr 2012, 04:27 PM
Hi friends,

I am trying to use the following expression
= Count(IIf(Fields.Customer='Daily'),Fields.Customer)   to count the number of records having The field customer as daily...But I am geeting an error..Cna Some one please let em know the right way of Using it?

Thank you

1 Answer, 1 is accepted

Sort by
0
Petio Petkov
Telerik team
answered on 02 May 2012, 07:47 AM
Hi,

Probably the following expression will do the work:
=Sum(IIf(Fields.Customer='Daily',1, 0))
More about the IIf function can be found in the Functions help article.

Regards,
Petio Petkov
the Telerik team

BLOGGERS WANTED! Write a review about Telerik Reporting or the new Report Designer, post it on your blog and get a complimentary license for Telerik Reporting. We’ll even promote your blog and help bring you a few fresh readers. Yes, it’s that simple. And it’s free. Get started today >

Tags
General Discussions
Asked by
akpaga akpaga
Top achievements
Rank 1
Answers by
Petio Petkov
Telerik team
Share this question
or