Calculate Week MTD,YTD Function

[Former Member]

How can we calculate Week MTD,YTD functions.

I am using Webi4.0

how can we implement this in report.Could you explain logic.

[harshil_joshi · Accepted solution]

(1) Make a variable named Current Date  =CurrentDate()

(2) another variable named Current Year =If(Month([Current Date]) InList("January")) Then(FormatNumber(Year([Current Date])-1;"###")) Else (FormatNumber(Year([Current Date]);"###"))

(3) then MTD =Concatenation(Left(FormatDate([Current Date];"dd/MM/yyyy");2) ;Concatenation("-";Concatenation(Concatenation(Left(Month([Current Date]);3);"-");Right(FormatNumber(Year(CurrentDate());"####");4))))

(4) YTD=Concatenation(Concatenation("Apr-";[Current Year]);If(MonthNumberOfYear([Current Date])=4)Then("") Else(Concatenation(" to ";Concatenation(Concatenation(Left(Month([Current Date]);3);"-");Right(FormatNumber(Year([Current Date]);"####");4)))))

Thanks & Regards.

[former_member188911]

Hello,

before asking you should please search, this question has been asked over and over in the past

For more info on how to use the SCN discussions, please refer to Rules of Engagement

Thanks

Best regards,

Simone Caneparo

SCN Discussions Moderator

[Former Member]

really i am sorry for disturb, but i am new in sap so i don't know all rules, sorry once again.

[former_member184594]

Hi Aya,

Check the WebI formula document. It gives enough and detailed information on how to use formulas in WebI.

http://help.sap.com/businessobject/product_guides/boexir4/en/xi4sp5_ffc_en.pdf

[former_member182342]

This message was moderated.