Sum function not working

[seth]

Hi I have some Issues with an expression that should be working but its instead outputting an empty result and I'm sure it should be working because it actually works for 1 of the 4 tables I'm printing on the report but not for the other 3.

the expression is the following: 

=IIf(Fields.BankMovementType = "TRANSFER", Exec("table1",Sum(NetPayment)),"")

which makes use of this calculated field:

NetPayment (Double) =IIf(Fields.BankMovementType = "TRANSFER", (Fields.Perception -  Fields.Deduction),0)

this actually gives me a sumatory of the NetPayment for all the "TRANSFER" movement types and leaves out the rest of the movement types, now I have tested this Expression multiple times and it works perfectly, however it only seems to be calculating for the "TRANSFER" movement type, in one table only. 

the other tables for the different forms of payment use the exact same formula, the only thing that changes is the condition:

=IIf(Fields.BankMovementType = "EFFECTIVE", Exec("table5",Sum(NetPayment)),"")

NetPayment (Double)  =IIf(Fields.BankMovementType = "EFFECTIVE", (Fields.Perception -  Fields.Deduction),0)

however this time around the field that is supposed to contain the sumatory is completely empty and I simply don't understand how this is possible, I know the parameter and the settings for the tables are exactly the same as I just copied and pasted the table and simply changed the condition for each different table.

I have also tried changing the expression to something like:

=IIf(Fields.BankMovementType = "EFFECTIVE", Exec("table4",IIF(NetPayment > 0,Sum(NetPayment),"")),"")

but it still shows empty and I just simply don't understand what is wrong with it, it doesn't even give any errors, it just simply doesn't do what its supposed to do...

I have attached images of the resulting tables to better understand what I'm trying to say, the first one is from the table that actually works and the second one is form the one that doesn't do its job. The final image is a picture of how they are structured on the designer.

 

 

[Katia]

Hello Seth,

Without knowing the exact settings of the report and the data used for the tables is would be hard to say what might be the cause of this issue.

Test using only the true part of the IIF function in the expression (= Exec("table4", IIF(NetPayment > 0, Sum(NetPayment), ""))). This will allow you to see if the condition Fields.BankMovementType = "EFFECTIVE" evaluates to false and to narrow the area which needs to be corrected.

To provide you further suggestions, post some sample data that is used for the problematic tables in a text format so we can test your scenario on our side.


Regards,
Katia
Progress Telerik

[seth]

I did just what you said and it actually worked, it is now calculating the sumatory field, I don't really understand why this is happening as the rest of the fields on the table use the exact same Expression end they are actually showing up on the table, for example this one:

=IIf(Fields.BankMovementType = "EFFECTIVE", Fields.CompanyBankName,"")

doesnt output any empty fields...

My only problem now is that its rounding up the numbers when adding up the fields for some reason, this is a big problem as the quantity displayed needs to be exact since this is a report for accounting. Is there a way to make the sum function not round up the numbers when calculating? I even changed the type of the calculated from 

NetPayment (Double)  =IIf(Fields.BankMovementType = "EFFECTIVE", (Fields.Perception -  Fields.Deduction),0)

to 

NetPayment (Decimal)  =IIf(Fields.BankMovementType = "EFFECTIVE", (Fields.Perception -  Fields.Deduction),0)

but it doesnt seem to change anything... I attached a picture of an example too.

[Katia]

Hello Seth,

Check this forum post which describes a possible solution for the issue you are having. The main idea is to use conversion functions to make sure that you work with the correct data type inside expressions.

Regards,
Katia
Progress Telerik

[seth]

I was already able to solve the problem, when I change the function to:

=Exec("table3",Sum(Ceiling(NetPayment * 100)/100))

it works as intended, I still don't know why the first table didn't give me so much trouble as compared to the other ones but its solved now...