Set analysis

[nareshthavidishetty]

Hi,

I'm getting the below error in set analysis.Please let me know the correct logic.

Thanks..

[sergio0592]

Hi, try:

sum($<[Reported Date]= {$(=V_MaxReportedDate)}>} [No Contract Total Amt])

where V_MaxReportedDate is a variable.

[Anil_Babu_Samineni]

Do you have the field maxreporteddate?

Can you elaborate more please

[vishsaggi]

Is your ReportedDate a different field. Are you trying something like this?

= Sum({$< [Reported Date] = '$(= Max(ReportedDate))'  >} [No Contract Total Amt])

[Anil_Babu_Samineni]

Vishwarath,

Do you mean this?

= Sum({$< [Reported Date] = {'$(=Max([Reported Date]))'}  >} [No Contract Total Amt])

[Anonymous]

Hi,

try this: sum(if([Reported Date]= ReportedDate, [No Contract Total Amt]))

[Anonymous]

let vMaxreported=Max([Reported Date])

sum({<[Reported Date] ={$(vMaxreported)}>}[No Contract Total Amt])

[#8]

U missed Curly brackets while passing values

[Anonymous]

sum({<ReportDate={'MaxReportDate'}>}NoContractAmount)

[eromiyasimon]

Hi,

= Sum({$< [Reported Date] = {'$(=Max(ReportedDate))'}  >} [No Contract Total Amt])

if the field name is maxreporteddate then the set analysis will be

= sum(${<[Reported Date] = {'MaxReportedDate'}>}[No Contract Total Amt])