cancel
Showing results for 
Search instead for 
Did you mean: 

BI4 WebI - Relative Date Function

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

amitrathi239
Active Contributor
0 Kudos

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])

Former Member
0 Kudos

I tried this way too but the result is the same date as Date Begin :

The attribute "Nombre à décaler" correspond to Number Null . This is the only attribute I can use for this kind of functionality. I don't know if the problem can arise from this.


amitrathi239
Active Contributor
0 Kudos

what is the values selected in the prompt "Nombre à décaler" ?

is it null or any value there?

Former Member
0 Kudos

The values integrated in the prompt are numbers.

This prompt have to be completed and only one value can be integrated.

I spoke about Number Null as the Univer's attribute used to be for this prompt.

amitrathi239
Active Contributor
0 Kudos

are yo getting 2 with the below variable?

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

Former Member
0 Kudos

No, the result is 0 ...

But I have 2 with this variable :

Var1 = userresponse("Nombre à décaler")