Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to add
max(if([Service.Service Code Raw] = 'H0046' ,[Service Payor.Date of Service]))) > (max(if([Service.Service Code Raw] = 'H0031' or [Service.Service Code Raw] = '90791',[Service Payor.Date of Service])))
into
max(if([Service.Service Code Raw] = 'H0031' or [Service.Service Code Raw] = '90791',[Service Payor.Date of Service]))
I tried this way. But I am getting blank space.
=if(
date(aggr(max(if([Service.Service Code Raw] = 'H0031' or [Service.Service Code Raw] = '90791')) , (max(if([Service.Service Code Raw] = 'H0046' ,[Service Payor.Date of Service]))) > (max(if([Service.Service Code Raw] = 'H0031' or [Service.Service Code Raw] = '90791',[Service Payor.Date of Service])))))
,[Service Payor.Date of Service])