Skip to Content
avatar image
Former Member

excel formula in WEBI XI3


Hello,

I would like to replicate the following excel formula in Webi XI3:

=year(a2)&"-"&if(isodd(month(a2)),month(a2)&"&"&Month(a2)+1,month(a2)-1&"&"&month(a2))

Could you please help me?

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    May 28, 2015 at 12:59 PM

    Hi ,

    Use below formula

    = FormatNumber(Year([Date]);"0")+"-"+ If( Mod( MonthNumberOfYear([Date]);2) = 1 ) Then MonthNumberOfYear([Date]) + "&"+ ToNumber(MonthNumberOfYear([Date]) +1 ) Else MonthNumberOfYear([Date]) -1 +"&"+MonthNumberOfYear([Date])

    Thanks,

    Tanveer

    Add comment
    10|10000 characters needed characters exceeded