Posted: Tue May 28, 2019 9:14 am Post subject: WebI formulas to Lumira
I have a report with WebI with a variable created from one of the dimensions. I am trying to do the same on Lumira but I am struggling. In WebI the formula would change the dates to just year depending on where the dates lie into a new variable.
Can anyone advise how I would do the calculation in Lumira? Going through the functions I have not seen one similar to Between that can be used in WebI
=If[Date] Between('01/01/2000;'31/12/2001) Then "00/01"
ElseIf [Date] Between('01/01/2001';'31/12/2002') Then "01/02"