AnsweredAssumed Answered

Calls Brought Forward Issue in CABI

Question asked by S.Vigneshkumar on Jun 2, 2015

 

Hi Support Team,

 

Am using below formula to get call forward to next month which are not resolved. Issue is these calls are taken forward to next month and not till, it is getting resolved. For ex Jan month call carry forward to Feb month and not on forthcoming months. Pls help to fix this

 

JAN

 

=Count([Ref Num]Where([Priority Symbol] = "2"And (MonthNumberOfYear([Open Date])=1)))+Count([Ref Num]

 

Where ([Priority Symbol] = "2" And (MonthNumberOfYear([Open Date])=12) And (MonthNumberOfYear([Resolve Date]) <>

 

12)))

 

______________________

 

FEB

 

=Count([Ref Num]Where ( [Priority Symbol] = "2"And (MonthNumberOfYear([Open Date])=2)))+Count([Ref Num]

 

Where([Priority Symbol] = "2" And (MonthNumberOfYear([Open Date])=1) And (MonthNumberOfYear([Resolve Date]) <>

 

1)))

 

___________________

 

MARCH

 

=Count([Ref Num]Where ( [Priority Symbol] = "2"And (MonthNumberOfYear([Open Date])=3)))+Count([Ref Num]

 

Where([Priority Symbol] = "2" And (MonthNumberOfYear([Open Date])=2) And (MonthNumberOfYear([Resolve Date]) <>

 

2)))

 

___________________

 

APRIL

 

=Count([Ref Num]Where( [Priority Symbol] = "2"And (MonthNumberOfYear([Open Date])=4)))+Count([Ref Num]

 

Where( [Priority Symbol] = "2" And (MonthNumberOfYear([Open Date])=3) And (MonthNumberOfYear([Resolve Date]) <>

 

3)))

 

__________________

 

 

 

 

 

MAY

 

=Count([Ref Num]Where( [Priority Symbol] = "2"And (MonthNumberOfYear([Open Date])=5)))+Count([Ref Num]

 

Where( [Priority Symbol] = "2" And (MonthNumberOfYear([Open Date])=4) And (MonthNumberOfYear([Resolve Date]) <>

 

4)))

 

__________________

 

JUNE

 

=Count([Ref Num]Where( [Priority Symbol] = "2"And (MonthNumberOfYear([Open Date])=6)))+Count([Ref Num]

 

Where( [Priority Symbol] = "2" And (MonthNumberOfYear([Open Date])=5) And (MonthNumberOfYear([Resolve Date]) <>

 

5)))

 

________________

 

JULY

 

=Count([Ref Num]Where([Priority Symbol] = "2"And (MonthNumberOfYear([Open Date])=7)))+Count([Ref Num]

 

Where([Priority Symbol] = "2" And (MonthNumberOfYear([Open Date])=6) And (MonthNumberOfYear([Resolve Date]) <>

 

6)))

 

______________________________

 

AUG

 

=Count([Ref Num]Where( [Priority Symbol] = "2"And (MonthNumberOfYear([Open Date])=8)))+Count([Ref Num]

 

Where( [Priority Symbol] = "2" And (MonthNumberOfYear([Open Date])=7) And (MonthNumberOfYear([Resolve Date]) <>

 

7)))

 

______________

 

SEP

 

=Count([Ref Num]Where( [Priority Symbol] = "2"And (MonthNumberOfYear([Open Date])=9)))+Count([Ref Num]

 

Where([Priority Symbol] = "2" And (MonthNumberOfYear([Open Date])=8) And (MonthNumberOfYear([Resolve Date]) <>

 

8)))

 

________________

 

OCT

 

=Count([Ref Num]Where( [Priority Symbol] = "2"And (MonthNumberOfYear([Open Date])=10)))+Count([Ref Num]

 

Where([Priority Symbol] = "2" And (MonthNumberOfYear([Open Date])=9) And (MonthNumberOfYear([Resolve Date]) <>

 

9)))

 

______________

 

NOV

 

=Count([Ref Num]Where([Priority Symbol] = "2"And (MonthNumberOfYear([Open Date])=11)))+Count([Ref Num]

 

Where( [Priority Symbol] = "2" And (MonthNumberOfYear([Open Date])=10) And (MonthNumberOfYear([Resolve Date]) <>

 

10)))

 

________________

 

DEC

 

=Count([Ref Num]Where( [Priority Symbol] = "2"And (MonthNumberOfYear([Open Date])=12)))+Count([Ref Num]

 

Where([Priority Symbol] = "2" And (MonthNumberOfYear([Open Date])=11) And (MonthNumberOfYear([Resolve Date]) <>

 

11)))

 

 

Regards,

Vignesh

 

 

 

Outcomes