Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Currently, I am using below expression to view my reports:
Count(
if([Col Segment]='N',if(Status<>'I',
if(len(trim([CRDE BizRules]))>0,AANUM))))
Now, I wish to add more filter to get my reports displayed items that matched with maximum date (refer to blue color) as below. However, I am getting null result:
Count({$<[Reporting Month]={'$(=max([Reporting Month]))'}>}
if([Col Segment]='N',if(Status<>'I',
if(len(trim([CRDE BizRules]))>0,AANUM))))
Please help me to input a correct expression for maximum Reporting Month.
Regards.
Thanks, I got it:
Count({$<[Reporting Month]={"$(=Date(max([Reporting Month]),'DD-MMM-YYYY'))"}>}
if([Col Segment]='N',if(Status<>'I',
if(len(trim([CRDE BizRules]))>0,AANUM))))
Your expression looks like good ..
Please check your [Reporting Month] format
Or please share some sample app.
Thanks, I got it:
Count({$<[Reporting Month]={"$(=Date(max([Reporting Month]),'DD-MMM-YYYY'))"}>}
if([Col Segment]='N',if(Status<>'I',
if(len(trim([CRDE BizRules]))>0,AANUM))))