SAP BO Webi Report Need Prompt (CurrentDate();-14)

[yoursraghu986]

Hi Team ,

Created Webi Report on Calculation view from Native Hanna.

we have Dimension : Material Created ondate .

My Requirement  is when user run report he want to see Last created material based on Current date and past 14 days Materials created . 

we return  query in Webi Report but when we execute its not fetching as per logic 

="From : " + (If(IsPromptAnswered("Material Creation Date(From)") = 0) Then (FormatDate(RelativeDate(CurrentDate();-14);"MM/dd/yyyy")) Else (FormatDate(ToDate(UserResponse("Material Creation Date(From)");"MM/dd/yyyy h:mm:ss a");"MM/dd/yyyy"))) + " To : " + (If(IsPromptAnswered("Material Creation Date(To)") = 0) Then (FormatDate(CurrentDate();"MM/dd/yyyy")) Else (FormatDate(ToDate(UserResponse("Material Creation Date(To)");"MM/dd/yyyy h:mm:ss a");"MM/dd/yyyy")))

can you help possible ways from Query Panel or Report Page ?

[nachtaktiv]

simplify your logic and check parenthesis