Referencing a column in set analysis

[#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

[linusblomberg]

why don't enter the expression for [Last date] instead. I've never tried to reference a column in set analysis but I usually make variables for my expressions already in the load script and that will work for you.

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

[jagan · Accepted solution]

Hi,

The calculations are done at chart level, not by row by row.  So we cannot use the Expression name in the Set analysis, instead you can below expression

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

** If the above expression then check for the date format of Date column and =Date(max({<Flag={"Disbursal"}>}Date)), both should be in the same format.

Regards,

Jagan.

[#4]

Thanks its work

[jagan]

Hi,

If you got the answer please close this thread by giving Correct and Helpful answers to the useful posts.

Regards,

Jagan.