topic Re: If statement NULL in App Development

If statement NULL

jamiemcc — Fri, 19 Nov 2021 12:35:59 GMT

Hi Guys,

How do i Only include the last 28 days using the If statement. Date is a dimension,If Date is not within the last 28 days its null.

=If (DateId = {">=$(=Max(DateId)-28)"} ,Date,null())

Jamie

AshutoshBhumkar — Fri, 19 Nov 2021 13:03:26 GMT

Hello,

Maybe below statement will help.

Expression : =If(Num(InvoiceDate) >=$(vMaxDate),Date(InvoiceDate),Null())

Variable for Max Date : =Max(InvoiceDate)-28 (Max Date in my data in 31-Dec-21).

Thanks,
Ashutosh