Skip to Content
avatar image
Tejas Shah

#MULTIVALUE Error while using Days between formula

Jan 24, 2018 at 08:40 PM | 32 Views

Hi,

I am trying to report number of days between today and query open date to make sure that they are less than or equal to 10 days. I am trying to use the following formula but it gives me #MULTIVALUE error. Please help.

=If DaysBetween(ToDate([Query Open Date];"DD/MM/YYYY");ToDate(CurrentDate();"DD/MM/YYYY"))<=10 Then Count([Query Status Name];All) Where([Query Status Name]="Open" And [Marking Group Name]="Site")

Regards,

Tejas Shah

SAP BusinessObjects - Web Intelligence (WebI)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    AMIT KUMAR
    Jan 24, 2018 at 08:55 PM

    currentdate() is already date data type.there is no need of to use todate() again.todate() is required if date object datatype is string. Check for query open date object data type.if it's date then remove to date from there also.

    Other than that use format "dd/MM/yyyy" if date type is string.

    Or try this.

    =if DaysBetween([Query Open Date];CurrentDate())<=10 Then Count([Query Status Name];All) Where([Query Status Name]="Open" And [Marking Group Name]="Site")

    Add comment
    10|10000 characters needed characters exceeded