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

Group total when a calculated field is used

1 Answer 200 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Yavor
Top achievements
Rank 1
Yavor asked on 13 May 2010, 01:01 PM
Hello!
I have a report that contains a grouping section. I have a calculated field in the details section with the following expression: 
= IIF(Fields.VatTermID=3, Fields.Amount,0), so for every record that has Fields.VatTermID=3 the textbox displays Fields.Amount and for the other records that textbox remains 0. That works fine. However I want to make a total of those fields in the group footer. I tried 
= SUM(IIF(Fields.VatTermID=3, Fields.Amount,0)), but it doesn't work. What expression should I use to get the total?

1 Answer, 1 is accepted

Sort by
0
Peter
Telerik team
answered on 17 May 2010, 09:07 AM
Hello Yavor,

Currently our aggregate functions don't support nested IIF. To achieve conditional sum we would suggest to use Events or User Functions

Let us know whether the proposed solution helps. If you need further assistance/directions please elaborate more on your exact scenario so we can advise you accordingly.

All the best,
Peter
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
Tags
General Discussions
Asked by
Yavor
Top achievements
Rank 1
Answers by
Peter
Telerik team
Share this question
or