1 Reply Latest reply on May 13, 2013 2:48 AM by SriniVEERAVALLI

    What's the correct formula to this?

      Hello experts,
      In one of my fact tables I need to have a calculation/formulas that will give the data for 3 months back (Feb 7 to May 7th this yeat), QTD (from April 1st to now) or CY (Jan 1st to now). So for instance I want to have cost for 3 months from Feb 7 to May 7th of this year and my fact table is "Fact - Sales Cost"."Cost".

      How do I insert the formula to so that it just gives me those particular data without going back to the rpd. I am sure there is way to use the functions. Please help

      Many thanks as always
        • 1. Re: What's the correct formula to this?
          In Criteria tab pull column "Fact - Sales Cost"."Cost" 3 times->fx->Filter->Select Year from Subject area and Add button 'SQL Expression' and then use year(current_year) this would be for CY.

          For other measures do the same, QTD you might need to tweak it based on your data.

          If helps mark

          Edited by: Srini VEERAVALLI on May 12, 2013 9:47 PM
          1 person found this helpful