
1. Re: Using a calculated field in a formula
Deepak Rai Oct 26, 2018 11:40 AM (in response to Himanshu Patil)1 of 1 people found this helpful({SUM(If Year([Date])=2017 and (Month([Date])<=6)THEN [Revenue] END)}/{SUM(If Year([Date])=2017 and (Month([Date])<=6)THEN [Unit] END)})
*
(({SUM(If Year([Date])=Year(TODAY())THEN [Visits] END)}))

2. Re: Using a calculated field in a formula
Himanshu Patil Oct 26, 2018 12:04 PM (in response to Deepak Rai)Thanks for the quick response Deepak. Your formula is almost correct but I'm getting a slight error. For 2018 each month seems to have the same value. I was hoping that the Visit number of a particular month gets multiplied by the Revenue/Unit (constant).

3. Re: Using a calculated field in a formula
Deepak Rai Oct 26, 2018 12:09 PM (in response to Himanshu Patil)1 of 1 people found this helpfulYour description was for year anyways
here it is:
({SUM(If Year([Date])=2017 and (Month([Date])<=6)THEN [Revenue] END)}/{SUM(If Year([Date])=2017 and (Month([Date])<=6)THEN [Unit] END)})
*
(({FIXED DATEPART('month', [Date]):SUM(If Year([Date])=Year(TODAY())THEN [Visits] END)}))
and here is view of result using denominator only

4. Re: Using a calculated field in a formula
Himanshu Patil Oct 26, 2018 1:24 PM (in response to Himanshu Patil)Thank you so much. You are a genius. I had to slightly modify your work to include a Fixed along my preferred Dimension.

5. Re: Using a calculated field in a formula
Deepak Rai Oct 26, 2018 1:33 PM (in response to Himanshu Patil)