Calculate all month

[Former Member]

Hi Friends,

suggest your valuable ideas and opinions Regarding my difficulties.

my requirement is need to develop the warranty report for fiscal Year.

But existing report they have developed for monthly based with

Mfg month object,code group,wheel code and some variable

I referred the existing report  just to get idea.but i could not find any solutions.

Mfg  month object both month & Year together

Ex: 2010 Apr

      2004 Aug

If i use code group and wheel code

Ex: Mfg  month     code group     wheel code

      2010 APr        werqwte         cb98

2010 Aug               widisc           abc

the above is the example without applying formula.

I need to consolidate for the fiscal year.

So plz suggest how to approach this

[Former Member]

try to create variable using below formula.

if month inlist('apr',.. , to , 'dec') then to_char(mfg)||'-'||to_char(mfg+1)

elseif month inlist('jan','feb','mar') then to_char(mfg-1)||'-'||to_char(mfg)

[Former Member]

Guys,

Help me ..Really working hard to get the output

[Former Member]

Sujitha,

Kindly help me plz

[Former Member]

http://scn.sap.com/community/businessobjects-web-intelligence/blog/2014/01/21/time-variablesdimensio...

[Former Member]

Hi sujitha,

I referred that link already..

But in my case i dont have date object seperately

mfg month object has both month&year.

depends on code group,wheel code to calculate total qty,total dispatch,no of wheels

[Former Member]

Add "01" default date to date and change datatype to date

= todate([mfg month]+"01";"yyyy Mmm dd")  // use this object