Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have used the below expression but it is not working.
Logic:
if([Calendar Date]>= date('31-May-2018'),'DD-MMM-YYYY') and [Calendar Date]<=date(max([Calendar Date],'DD-MMM-YYYY'),num(Sum({$< [PA Age Days 365 Flag]= {'Y'},[Monthly Snapshot Flag]= {1},[%Confirmed PA Flag]={'Y'}>}[# PA Open]),'#,##0',null()))
Thanks..
try like this
if([Calendar Date]>= date('31-May-2018','DD-MMM-YYYY')
and [Calendar Date]<=date(max([Calendar Date],'DD-MMM-YYYY')),
num(Sum({$< [PA Age Days 365 Flag]= {'Y'},[Monthly Snapshot Flag]= 1,[%Confirmed PA Flag]={'Y'}>}[# PA Open]),'#,##0')
,null())
One correction could be like:
if([Calendar Date]>= date#('31-May-2018','DD-MMM-YYYY') and ....
Note, date#() and a bracket correction..
try this
if([Calendar Date]>= date('31-May-2018','DD-MMM-YYYY') and [Calendar Date]<=date(max([Calendar Date]),'DD-MMM-YYYY'),
num(Sum({$< [PA Age Days 365 Flag]= {'Y'},[Monthly Snapshot Flag]= {1},[%Confirmed PA Flag]={'Y'}>}[# PA Open]),'#,##0',null()))
Try this:
if([Calendar Date]>= date#(('31-May-2018'),'DD-MMM-YYYY') and
[Calendar Date]<= date#(max([Calendar Date]),'DD-MMM-YYYY'),
num(Sum({$<[PA Age Days 365 Flag]= {'Y'},[Monthly Snapshot Flag]= {1},[%Confirmed PA Flag]={'Y'}>}
[# PA Open]),'#,##0'),null())
Bracket misplaced in 3 places.
try like this
if([Calendar Date]>= date('31-May-2018','DD-MMM-YYYY')
and [Calendar Date]<=date(max([Calendar Date],'DD-MMM-YYYY')),
num(Sum({$< [PA Age Days 365 Flag]= {'Y'},[Monthly Snapshot Flag]= 1,[%Confirmed PA Flag]={'Y'}>}[# PA Open]),'#,##0')
,null())