This discussion is archived
1 Reply Latest reply: May 12, 2013 7:48 PM by Srini VEERAVALLI RSS

What's the correct formula to this?

997624 Newbie
Currently Being Moderated
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?
    Srini VEERAVALLI Guru
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points