Skip to Content
avatar image
Former Member

Calculate all month

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Dec 23, 2014 at 07:34 AM

    Guys,

    Help me ..Really working hard to get the output

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 23, 2014 at 05:43 PM

    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)

    Add comment
    10|10000 characters needed characters exceeded