Adding a value to a calculated Sum

[sstankiewicz]

I have a sum formula that add the value of my items based on their statuses, (my data rows each have a status and three different $ Values and depending on the status of the item is which $ value I want to include in the total) then I want to add that total to my original budget in the Group footer, but I keep getting an error below. Must be something simple I'm just overlooking because both values work separately. It just won't let me add them together. MRT is attached. Thanks,:

Stimulsoft Sum Problem 20230213.jpg (382.72 KiB) Viewed 284 times

Stimulsoft Sum Problem Preview 20230213.jpg (59.88 KiB) Viewed 284 times

[Lech Kulikowski]

Hello,

The IIF() function returns an object type value, you should convert it in the correct type.

Thank you.

[sstankiewicz]

Hi Lech. Thanks for the quick reply, but I'm still not having any luck. Can you provide an example? (Sorry, I'm not a programmer. ) Thanks for your help!

[Lech Kulikowski]

Hello,

Could you send us your report with test data, we will find the solution for you.

Thank you.