Running Sum syntax in BO 4.1

[Former Member]

Hi,

I have a webi report created in BO 4.0 version. The report is a crosstab and contains variables for running sum. The variable syntax looks like

=RunningSum(If IsNull([measure]) Then 0 Else ([measure]);Row;([dimension1];[dimension2]))

But when the BO got upgraded from 4.0 to 4.1 the above variable does not calculate the running sum as expected.

When I changed the variable to below formula it is now working fine and gives correct running sum value.

=RunningSum(If IsNull([measure]) Then 0 Else ([measure]);Col;([dimension1];[dimension2]))

Is there a change in running sum syntax with the 4.1 upgrade?

[abhinav_shrivastava1]

Hi Sampada,

So with your initial formula, I think you wanted to Reset the Running Sum for Each Row.

Can you share the initial version of BI4.0 you was on and which SP of BI4.1 you upgraded to?

Also can you replicate this behavior on eFashion Universe?

Regards,

Abhi