Calculate opening balance

[arulsettu]

Hi,

     I am trying to show opening balance. i am having month field

TBAL_CAL_MONTH

0

1

2

3

4

5

6

7

8

9

10

11

12

if i select 7th month it should show the value of 0-6 th month as opening balance

i tried below code but no luck

sum({<TBAL_CAL_MONTH={">=$(=MonthsStart(Date(Max(TBAL_CAL_MONTH))))<=$(=Max(Date(TBAL_CAL_MONTH)))"}>}TBAL_MTD_DR_LC_1-TBAL_MTD_CR_LC_1)

plz suggest

thanks

[arulsettu]

is this Rolling month?

plz suggest some advice

[arulsettu]

any solutions?

[preminqlik]

hi der

try this

sum({<TBAL_CAL_MONTH={">=$(=min({1}TBAL_CAL_MONTH))<$(=max(TBAL_CAL_MONTH))"}>}TBAL_MTD_DR_LC_1-TBAL_MTD_CR_LC_1)

[arulsettu]

Hi

     thanks for replying but it showing zeros only

[#6]

try this:

sum({<TBAL_CAL_MONTH={"<$(=Max(TBAL_CAL_MONTH))"}>}TBAL_MTD_DR_LC_1-TBAL_MTD_CR_LC_1)

is there a year field?

[preminqlik]

post sample data

[simsondevadoss]

RangeSum(Above(sum( {<TBAL_CAL_MONTH={"<$(=Max(TBAL_CAL_MONTH))"}>}TBAL_MTD_DR_LC_1-TBAL_MTD_CR_LC_1),0,RowNo()))

[arulsettu]

here is the sample app

[arulsettu]

Hi Simson,

               Thanks for reply but the result is not correct