Refrencing a column calculation

[#1]

Dear all

I am facing a problem i have an expression which are given below having label 'Last date'

max({<Flag={'Disbursal'}>}Date) 

when ever i reference the column in other  expression which are given below

=Sum({<Flag={'Disbursal'},Date={'[Last date]'}>}AMOUNT

)

it give me 0 rather than given me the amount of that date

[amit_saini]

Asif,

Try this:

=Sum({<Flag={"Disbursal"},Date={"[Last date]'"}>}AMOUNT)

Thanks,

AS

[#3]

it cant works return 0

when i reference the column [Last date] it gives number rather than date

[martinpohl]

It doesn't work with set analysis only, you have to mix it with the max date for each dimension (in that case by customer.

sum( if( aggr(nodistinct max({<Flag={'Disbursal'}>}Date), Customer) = Date, Amount, 0))

Regards

[chrislofthouse]

Try this:

Sum({<Flag={'Disbursal'},Date={"$(=max({<Flag={'Disbursal'}>}Date) )"}>}AMOUNT)

[#6]

Thanks it works

[jagan]

Hi,

Try this expression

=Sum({<Flag={'Disbursal'},Date={'$(=Date(max({<Flag={"Disbursal"}>}Date)))'}>}AMOUNT)

Regards,

Jagan.