calendar yr to indian financial yr and Quarter

[kunkumnaveen]

Hello,

which function do i need to use to achieve this

        jan

        feb

        mar  as Q4 2015

        apr

        may

        jun as Q1 2016

        July

        aug

        sep as Q2 2016

        oct

        nov

        dec as Q3 2016 

and actual/calendar year is 2015

current my expression is this which is not good

'Q'&ceil(MONTH(DATE)/3) AS QUATERS,

    year(DATE) as YEAR

thanks

naveen

[kunkumnaveen]

plz find my attached sample file

[sunny_talwar]

Sample qvw won't be much useful without the database files to reload. I will still try to work on another sample and see if you can copy the logic over to yours

[kunkumnaveen]

yes i forgot,thanks

[sunny_talwar]

Here you go, try this:

SuppilerScore:

LOAD  VENDOR_NAME,

     ROLE,

      date(date#(DATE_OF_REVIEW,'YYYY-MM-DD')) as DATE_OF_REVIEW ,

     QM_SCORE,

     CS_SCORE,

     GENERAL_SCORE,

     PROC_SCORE,

     MANU_SCORE,

     round(TOTAL_SCORE) as TOTAL_SCORE,

     Dual('Q' & Ceil((Mod(Month(DATE_OF_REVIEW) - $(vFiscalYearStartMonth), 12)+1)/3),

     Ceil((Mod(Month(DATE_OF_REVIEW) - $(vFiscalYearStartMonth), 12)+1)/3)) as QUATERS,

     YearName(DATE_OF_REVIEW, 0, $(vFiscalYearStartMonth)) AS YEAR

FROM

[..\QVDS\SuppilerScore.qvd]

(qvd);

[kunkumnaveen]

IF I NEED TO GET month then

[sunny_talwar]

Naveen not sure if you are asking me or Nitin? Did the above response work for you or not?

[Anonymous]

justr use month(DATE_OF_REVIEW)