Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Restrict Running sum in Webi

Hallo Experts,

I have following requirement. I am creating a webi report on BEx query which customer exits for YTD Calculation and Structure for Month

I need to show the data like this when User Selects JUN 20XX for the prompt.

MonthDeliveriesRunningSum

JAN

11
FEB23
MAR36
APR410
MAY515
JUN621
JUL
AUG
SEP
OCT
NOV
DEC

But when I use =Runningsum(Deliveries)  I am getting following result

MonthDeliveriesRunningSum

JAN

11
FEB23
MAR36
APR410
MAY515
JUN621
JUL21
AUG21
SEP21
OCT21
NOV21
DEC21

Can anyone suggest me solution or work around to restrict the values for RunningSum only for the values visible.

THanks

Indra

Tags:
Former Member
Former Member replied

Try Below Formula

=If  Not(IsNull([Value])) Then Runningsum(Deliveries)

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question