Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a scenario as below.
There are two column [Report Due Date] and [Revenue In Rs].
The column [revenue in Rs] to be updated the last date was 06/08/2016 (6th August) but it was not update hence i should see a message as SLA breached.Attached the sample input and output data.
Can someone pls help me with this.
Thanks
May be this:
If(
(Len(Trim([Revenue In Rs])) = 0 or [Revenue In Rs] = 0)
and
Today() > [Reveneue Due Date], 'SLA Breached') as [NEW COLUMN]
May be like this:
If(Len(Trim([Revenue In Rs])) = 0, 'SLA Breached') as [NEW COLUMN]
We have to consider the Report due date also. If the report due date was 6th Aug and the [Revenue in Rs] was not updated then a msg to appear as SLA breached.
Such as below condition
IF Systemdate>Reveneue Due Date and Revenue in Rs is null or = 0 then update as SLA BREACHED else do nothing.
May be this:
If(
(Len(Trim([Revenue In Rs])) = 0 or [Revenue In Rs] = 0)
and
Today() > [Reveneue Due Date], 'SLA Breached') as [NEW COLUMN]
Sunny it worked perfectly. Thanks again
No problem, I am glad I was able to help once again