Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

Tags:
Former Member
replied

Hi ,

Create a variable as Date with formula as below

Date = todate([Billing Month];"yyyyMM")

after that use the below formula as i suggested in the above reply

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


let me know how this works


Thanks,

Tanveer.

1 View this answer in context
Not what you were looking for? View more on this topic or Ask a question