Skip to Content
author's profile photo
Former Member

Year to date etc...

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.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • author's profile photo
    Former Member
    Posted on Jan 04, 2008 at 04:10 PM

    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

    Add comment
    10|10000 characters needed characters exceeded