I intend to create a table to display a 'Message' in an IF condition. The IF condition is between 9-12 months of data and a specific Status, while the other IF condition is 3-6 months of data
This is my expression,
=Maxstring(
if(
{<[Proposal Approval Date]={">=$(=Date(AddMonths(LasRefresh,-12))) <=$(=Date(AddMonths(LasRefresh,-9)))"}
,[Status]= 'In Progress')
if
{<[Proposal Approval Date]={">=$(=Date(AddMonths(LasRefresh,-6)))""<=$(=Date(AddMonths(LasRefresh,-3)))"}
,[Status] = 'Completed'))
>}'Expired')
