Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Introduction first :
[tesIn] is Year-Month name
[In] using Sum(InVal)
[Out] using Sum(OutVal)
[Outstndg] is using this formula = [In]-[Out]+[OB], and right now i'm using this expression :
= (if(len(trim(above(Sum(InVal) - Sum(OutVal))))=0,Sum(InVal) - Sum(OutVal),Sum(InVal) - Sum(OutVal)+above(Sum(InVal) - Sum(OutVal))))
[OB] is the above value of [Outstndg], right now I'm using this expression :
= above(if(len(trim(above(Sum(InVal) - Sum(OutVal))))=0, Sum(InVal) - Sum(OutVal), Sum(InVal) - Sum(OutVal)+above(Sum(InVal) - Sum(OutVal))))
The result is like this
if you see the red colored box, the result is correct. But if you see the blue colored box, the result is wrong, the right value for the Outstndg is 109-90+17 = 36
This is the raw data
Is there any solution ?
Ok i already found the answer,
Right now im using this expression
Outstndg :
if(len(trim(above(Sum(InVal) - Sum(OutVal))))=0,Sum(InVal) - Sum(OutVal),Sum(InVal) - Sum(OutVal)+RangeSum(above(Sum(InVal)-Sum(OutVal),1,(RowNo()))))
OB :
above(if(len(trim(above(Sum(InVal) - Sum(OutVal))))=0,Sum(InVal) - Sum(OutVal),Sum(InVal) - Sum(OutVal)+RangeSum(above(Sum(InVal)-Sum(OutVal),1,(RowNo())))))
Ok i already found the answer,
Right now im using this expression
Outstndg :
if(len(trim(above(Sum(InVal) - Sum(OutVal))))=0,Sum(InVal) - Sum(OutVal),Sum(InVal) - Sum(OutVal)+RangeSum(above(Sum(InVal)-Sum(OutVal),1,(RowNo()))))
OB :
above(if(len(trim(above(Sum(InVal) - Sum(OutVal))))=0,Sum(InVal) - Sum(OutVal),Sum(InVal) - Sum(OutVal)+RangeSum(above(Sum(InVal)-Sum(OutVal),1,(RowNo())))))