# 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