Finding a difference in a cross tab

[Yogesh]

I am trying to find a difference between 2 values in the corss tab total by using iff and sum since there is no diff or subtract function. How do i do it. Not looking to do in code but in the designer itself using an expression.

[Massimiliano Bassili]

There is a "-" operator (Operators)

[Yogesh]

Yes but my date is structured differently. This is what my sql query returns. And i when i make the crosstab query it gives me the total at the bottom as 150 which is fine, but i need a net meaning payment minus refund. I tried using iif condition to add anything that says payment and subtract anything that says refund, but no luck to create the difference. I want the subtotal to return 50 not 150. Please help.

Type                  Amount
Payment 100
Refund            50

[Squall]

What expression you have used? I have done something similar:

= Sum(IIF(Fields.Label ="Refund", -Fields.Amount, Fields.Amount))

[Yogesh]

I tried in 2 ways.
First one

=iff(Fields.Type='Payment', Sum(Fields.Amount,0))-iff(Fields.Type='Refund', Sum(Fields.Amount,0))

Second way
=sum(iif(Fields.Type='Payment', Fields.Amount,0)-sum(iif(Fields.Type='Refund', Fields.Amount,0)

And none of those syntax work... 

[Peter]

Hi Yogesh,

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.

Kind regards,
Peter
the Telerik team