Stimulsoft Business Intelligence System | Forum

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,:

Hello,

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

Thank you.

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!

Hello,

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

Thank you.