
1. Re: How to use Fixed Calculations?
Derrick Austin May 4, 2016 1:55 PM (in response to nick.cook.0)Hey Nick,
It sounds like you should fix your calc to Campaign, Timing, and (I assume) time period.
{FIXED [Campaign], [Timing], [Time Period] : SUM([Prospects)}
Hope this helps!
 Derrick

2. Re: How to use Fixed Calculations?
pooja.gandhi May 4, 2016 1:59 PM (in response to nick.cook.0)1 of 1 people found this helpfulNick!
That would be a calc like this:
{ fixed [Campaign ID]: sum([Prospects]) } / { fixed [Campaign ID] : countd([Market]) }
The numerator gives 400 and the denominator gives a 4!

3. Re: How to use Fixed Calculations?
Ashish Chaudhari May 4, 2016 3:45 PM (in response to nick.cook.0)Hi Nick,
If the records are duplicated, then you should be worried about your database. This was really easy if you could have done the proper structuring referring to the RDBMS rules. Doing such a YTD and MTD differentiation is really a thing which is not suggested to do. The reason I am saying this is because for every simple calculation you will have to face the problem of duplication and you need to somehow manipulate the data to get the desired result (which isn't standard) .
If possible please change the data structure to avoid getting stuck with all your future calculations. You will always end up getting altering them for your duplicate data.
Thanks and Regards,
Ashish Chaudhari

4. Re: How to use Fixed Calculations?
John Sobczak May 4, 2016 4:48 PM (in response to pooja.gandhi)Pooja, This works for these values, but if there were possibly more value outcomes for the timing and response type then I don't think it will be right answer. I think Derrick's calc will survive this.