RangeSum issue

[agni_gold]

Hi All,

I have issue like below , as we can see extra days are coming , i am trying to restrict days till it has data

Actual :

= RangeSum(above(Sum({<[Segment Entity]-= {""},Date= {">=$(=Min([Month Start Date]))<=$(v_Date)"}> }[ERP Amount USD])/1000000,0,
  Sum({<Date= {">=$(=Min([Month Start Date]))<=$(v_Date)"}> }Day)) )

AOP:

= RangeSum(above(Sum({<[Segment Entity]-= {""},Date= {">=$(=Min([Month Start Date]))<=$(v_Date)"}> }[Target Budget])/1000000,0,
  Sum({<Date= {">=$(=Min([Month Start Date]))<=$(v_Date)"}> }Day)) )

Please help.

[marcus_sommer]

There are several possibilities, for example the way you create the day-dimension and if show all values is enabled and/or the surpressing of NULL witin the tab presentation isn't enabled and I would probably change the expression to:

= RangeSum(above(Sum({<[Segment Entity]-= {""},Date= {">=$(=Min([Month Start Date]))<=$(v_Date)"}> }[ERP Amount USD])/1000000,0,
  Sum({<Date= {">=$(=Min([Month Start Date]))<=$(v_Date)"}> }Day) rowno(total)) )

- Marcus

[Kushal_Chawda]

try this

= RangeSum(above(Sum({<[Segment Entity]-= {""},Date= {">=$(=Min([Month Start Date]))<=$(v_Date)"}> }[Target Budget])/1000000,0, rowno())
  Sum({<Date= {">=$(=Min([Month Start Date]))<=$(v_Date)"}> }Day))

[agni_gold]

No friend it does not making any change

[Kushal_Chawda]

this?

= RangeSum(above(Sum({<[Segment Entity]-= {""},Date= {">=$(=Min([Month Start Date]))<=$(v_Date)"}> }[Target Budget])/1000000,0, rowno(Total)),
  Sum({<Date= {">=$(=Min([Month Start Date]))<=$(v_Date)"}> }Day))

[agni_gold]

I have tried both , but same answer