• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 432
  • Last Modified:

WebI Purge Data #error when UserResponse and ToDate function is used in same formula

I have a formula which works well when there is data but when I purge the webi report I get #Error for the cells wherever I have used UserResponse and ToDate function in the same formula.
Ex: =FormatDate(ToDate(UserResponse("Enter Modified Date:");"M/dd/yyyy hh:mm:ss a");"MM/dd/yyyy")
Is this known issue? If anyone knows the solution. Please answer it.
(FYI, I am using BO4.0 SP5)
1 Solution
nishant joshiTechnology Development ConsultantCommented:
Hi Naveen,

You can use IsNothing() function to check whether value exist or not.If value is not exist then assign date '1900-01-01'.

=FormatDate(ToDate((IIF(IsNothing(UserResponse("Enter Modified Date:")),'1900-01-01',UserResponse("Enter Modified Date:"));"M/dd/yyyy hh:mm:ss a");"MM/dd/yyyy"))

Open in new window

naveenreddyinusAuthor Commented:
FYI, WebI doesn't have a function called "IsNothing".
When you purge the data it also purges the response to the prompt thus the error indication.

You can try using the IsPromptAnswered function.

I don't have a WebI environment here but I will check the format in the morning.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now