Update new Column Based on the condtion

[#1]

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

[sunny_talwar]

May be like this:

If(Len(Trim([Revenue In Rs])) = 0, 'SLA Breached') as [NEW COLUMN]

[#3]

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.

[sunny_talwar · Accepted solution]

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]

[#5]

Sunny it worked perfectly. Thanks again

[sunny_talwar]

No problem, I am glad I was able to help once again