Adding a value to a calculated Sum

Stimulsoft Reports.WPF discussion
Post Reply
sstankiewicz
Posts: 3
Joined: Fri Feb 19, 2021 2:34 pm

Adding a value to a calculated Sum

Post by 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
Stimulsoft Sum Problem 20230213.jpg (382.72 KiB) Viewed 8100 times
Stimulsoft Sum Problem Preview 20230213.jpg
Stimulsoft Sum Problem Preview 20230213.jpg (59.88 KiB) Viewed 8100 times
Lech Kulikowski
Posts: 6197
Joined: Tue Mar 20, 2018 5:34 am

Re: Adding a value to a calculated Sum

Post by Lech Kulikowski »

Hello,

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

Thank you.
sstankiewicz
Posts: 3
Joined: Fri Feb 19, 2021 2:34 pm

Re: Adding a value to a calculated Sum

Post by 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
Posts: 6197
Joined: Tue Mar 20, 2018 5:34 am

Re: Adding a value to a calculated Sum

Post by Lech Kulikowski »

Hello,

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

Thank you.
Post Reply