5 Answers, 1 is accepted
What expression you have used? I have done something similar:
= Sum(IIF(Fields.Label ="Refund", -Fields.Amount, Fields.Amount))
=iff(Fields.Type='Payment', Sum(Fields.Amount,0))-iff(Fields.Type='Refund', Sum(Fields.Amount,0))
=sum(iif(Fields.Type='Payment', Fields.Amount,0)-sum(iif(Fields.Type='Refund', Fields.Amount,0)
And none of those syntax work...
Generally the suggested solution should work. Check out the attached sample, to run it you only have to copy the archived files in our report examples project, that came with your Telerik Reporting installation.
If you still experience any further difficulties we will appreciate if you open support thread and send us a runnable sample to review on our end.
the Telerik team
See what's new in Telerik Reporting Q1 2013. Register for the March 4 webinar to witness the impressive new visualizations in Telerik Reporting. Just for fun, 10 webinar attendees will be randomly selected to win a Telerik T-shirt and a $50 Gift Certificate to ThinkGeek. Register now! Seats are limited!