Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm getting the below error in set analysis.Please let me know the correct logic.
Thanks..
Hi, try:
sum($<[Reported Date]= {$(=V_MaxReportedDate)}>} [No Contract Total Amt])
where V_MaxReportedDate is a variable.
Do you have the field maxreporteddate?
Can you elaborate more please
Is your ReportedDate a different field. Are you trying something like this?
= Sum({$< [Reported Date] = '$(= Max(ReportedDate))' >} [No Contract Total Amt])
Vishwarath,
Do you mean this?
= Sum({$< [Reported Date] = {'$(=Max([Reported Date]))'} >} [No Contract Total Amt])
Hi,
try this: sum(if([Reported Date]= ReportedDate, [No Contract Total Amt]))
let vMaxreported=Max([Reported Date])
sum({<[Reported Date] ={$(vMaxreported)}>}[No Contract Total Amt])
U missed Curly brackets while passing values
sum({<ReportDate={'MaxReportDate'}>}NoContractAmount)
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])