Calculate number of days for particular status!

[buzzy996]

Hello,

Could you assist to bring the attached sheet "ExpectedOUTPUT" column values?

thanks

[buzzy996]

Hi Braga,

PFA,Kindly look at the comparison columns "Braga Expression O/P" v/s "Shiva Expected O/P".

hope the attached one will give clear picture,what i'm expecting.

thanks in advance.

[buzzy996]

Hi Juan,

could u look at the attached one,and kindly help..this give more clarity what i'm expecting.

thx

[miguelbraga]

I'll take a look at what your requirements and try my best to get your desired results.

[miguelbraga]

Hi again,

Perhaps you can do something like this:

=if( isnull ( above( Sum({$<STATUS = {"Awaiting Reply"}>} LASTCHANGEDTS) ) ),  if("insert here my expression"=0, 0, 1), 3)

Hope it helps

[miguelbraga]

Any sugestionsgwassenaar‌;sunindia‌; hic‌; jontydkpi‌; swuehl‌?