on 01-31-2018 10:10 AM
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
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])
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
82 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.