Straight Table Calculation...

[israrkhan]

Hi Guys..

i have a table like below..

in straight table i want to calculate the balanceamount, my dimension is DocCode,

and expression is sum({<DISTDATE = {"<= $(=Max(Date(DISTDATE,'DD/MM/YYYY')))"}>} BalanceAmount)

its giving me 0,

let say if i select date 20/04/2014, the balance amount must be 500,

and if i chose date 22/04/2014 the balanceamount must be 300, (which is 500-200)

date format is DD/MM/YYYY..

HOW TO USE <= OPERATOR IN SET ANALYSIS....VERY SIMPLE BUT NOT WORKING ....

PLEASE SUGGEST....

Header 1	Header 2	Header 3
DocCode	DisDate	Amount
1	20/04/2014	500
1	22/04/2014	-200
1	25/04/2014	-300
2	30/04/2014	800

[sunny_talwar · Accepted solution]

Try by creating a variable and then doing it.

It worked for me when I did this:

vMaxDate = Date(Max(DisDate))

Expression: Sum({<DisDate = {'<=$(vMaxDate)'}>} Amount)

HTH

Best,

S

[hic]

You need to use

   =Date(Max(DISTDATE),'DD/MM/YYYY')

instead of

   =Max(Date(DISTDATE,'DD/MM/YYYY'))

HIC

[#4]

Hi,

Use this Application.

Regards

Vimlesh

[awhitfield]

Can you post a sample of the data being loaded in an xls, the names of fields in you screen shot appear to be different from those in the expression formula.