1 Reply Latest reply: Apr 16, 2012 12:08 PM by MKKrishna RSS

    Value going foward

    820502
      Hello,

      I have the below formula in OBIEE Answers and what i am trying to do is find the headcount number in the past and future, it is the future i am have problems with. I know in OBIEE this only shows today and the past but i would like the headcount number for today go against the number of the future.

      CASE WHEN Time."Day Of Month" >= DAY(CURRENT_DATE) THEN FILTER("Headcount Facts"."Employee Headcount" USING Time."Day Of Month" = DAY(CURRENT_DATE)) ELSE "Headcount Facts"."Employee Headcount" END

      I thought this would work but it stops when = todays date and i want it to continue, and i would like it to hold this value for future dates.

      Hope this makes sence any questions please let me know.

      Thank you

      John
        • 1. Re: Value going foward
          MKKrishna
          Does your system allow hold data for the future?

          FILTER("Headcount Facts"."Employee Headcount" USING Time."Day Of Month" = DAYofmonth(CURRENT_DATE) ) - Current Date Head count
          FILTER("Headcount Facts"."Employee Headcount" USING Time."Day Of Month" > DAYofmonth(CURRENT_DATE) ) - Future Date Head count