SUM with IIF incorrectly rounding when expecting 2 decimals

[Kerry]

I've found an issue where if you have a textbox using an expression

 Sum(IIF(Fields.typeCode="DG",Fields.TotalAmount,0))  will round your result up or down regardless of the Format of the control,  when I change it to ....Sum(IIF(Fields.typeCode="DG",Fields.TotalAmount,0.00)) the results are NOT rounded.

To recreate this you must ensure the the first record in your result set causes the IIF condition evaluates to the false-part first meaning it will sum the 0.  I'm assume the report engine processes the "0" and automatically defaults the number of decimals to match the format of 0....if the engine encounters 0.00 it auto formats to use 2 decimal places. You will not see this behavior if the IIF evaluates the true-part first with existing decimal data.  Using Telerik Reporting ver 6.0.12.215

Thanks,

Kerry 

[Steve]

Hello Kerry,

Check the following forum thread for explanation on this behavior: Sum function round to zero decimal places.

Greetings,
Steve
the Telerik team

[derek]

Thank you so much.  From looking at the problem I was having I thought "This makes no sense", but after looking at your post I realized that the "0" was the problem.  The Fields.Amount is a decimal variable, but 0 is an integer, so the returned value in either piece is an integer (the lowest common denominator of decimal and integer) -- or at least that sort of thing.  So changing my expressions to 0.00 did what I wanted/expected.

I didn't follow through to the other posts.  I don't even think I finished reading the original post but it solved my problem, so thank you.