Skip to Content
0
Dec 12, 2013 at 06:59 AM

Quarterwise using if else Condition

24 Views

HI,

i having Object Call/month,it will give the values like

04.2013

05.2013

06.2013

07.2013

08.2013

09.2013

10.2013

11.2013

in this above

monthno 06=Q1,09=Q2,12=Q3

for this created one variable taking month no using following formula

V_OSOD MonthNo

=Left([Calendar Year/Month];2)

it will give month number like ,06,07,08,09,11,12,,,

again i have created one variable for spliting quarterwise

V_OSOD Quarterwise

=If([V_OSOD MonthNo])="06" Then "Q1" ElseIf [V_OSOD MonthNo] ="05" Then "Q1" Else If [V_OSOD MonthNo] ="09" Then "Q2 " ElseIf [V_OSOD MonthNo] ="12" Then "Q3"

in this above Call/month values 12th month is not there ,that time i have take 11 month as Q3,How?

suppose for exmple i having 04.2013,

05.2013,

06.2013,

07,2013,,,,this time i have to take Month No 06 as Q1,,,,,,07 as Q2

Plz help i hope you will understand

if i apply or condition it is summing the value using following formula

=If([V_OSOD MonthNo])="06" Or [V_OSOD MonthNo] ="05" Then "Q1" Else If [V_OSOD MonthNo] ="09" Then "Q2 " ElseIf [V_OSOD MonthNo] ="12"

Or [ V_OSOD MonthNo] ="11" Then "Q3"

Attachments

Count.JPG (36.5 kB)