Year to date etc...

[Former Member]

Post Author: Optimus

CA Forum: Desktop Intelligence Reporting

Hi all,fro the first time I am trying to implement a year-to-date , month-to-date and similar measures into my reports. I tried approach with second data provider with restriction to date; the problem is, I can not write something like WHERE measures.year = Year(CurrentDate()) - 1 (for last year measure) Please, what is standard approach to calculated measures that I need?Thank you.

[Former Member]

Post Author: Peter@KLM

CA Forum: Desktop Intelligence Reporting

make a variable like this: FlagCY = If (measure.year = year(CurrentDate()) then "CY" Else "PY"

and two others:

TurnoverCY = <Turnover> where (<_Flag_CY> = "CY")

TurnoverPY = <Turnover> where (<_Flag_CY> = "PY")

Now you can do anything you like with these two variables