Skip to Content
avatar image
Former Member

BI4 WebI - Relative Date Function

Hi everyone,

I work on BI4 WebI.

As you can see on the screen, I have to calcul "Date Updated". To do this, I have to take the Date Begin (which is extract by a date on the filters on the right) and take off the number present in the filter : "Nombre à décaler".

I found that the formule have to use RelativeDate.

1) First, I tried to do this :


=DateRelative([Request 1].[Date begin];RéponseUtilisateur([Request 1];"Nombre à décaler")) But an error is returned.


2) Then I tried to insert
=RéponseUtilisateur([Request 1];"Nombre à décaler") in a variable. It doesn't work too.


Does an other formul exist to solve this case?

Thanks by advance

number-x-on-date.png

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Feb 01 at 11:58 AM

    try with these steps.change function name accroding to your langaue.

    Var 1=tonumber(userresponse("Nombre à décaler"))

    =RelativeDate([Request 1].[Date begin];[Var 1])

    Add comment
    10|10000 characters needed characters exceeded