 Rank: Newbie
Groups: extranet\Forum
Joined: 11/5/2018(UTC)
Posts: 1
|
I am trying to figure out how I can use Targit to calculate a run rate on a given set of data. I am using dynamic period of Month to Date (MTD) on various measures and want to be able to calculate out what the projected full month results will be.
So, for example, if my MTD is as of September 10th and the measure totals $10,000, I want to use a formula that will take the $10,000 divide by 10 days and multiply by 30 days in September to get a Run Rate of $30,000.
Is this at all possible?
Any help is appreciated
|
|
|
|
|
|
 Rank: Administration
Groups: extranet\Forum
Joined: 4/7/2011(UTC)
Posts: 514
|
Hi Matthew,
You can do it in TARGIT - however, not in an easy manner.
It will require that your data set in the TARGIT client include data down to the day level and you somehow are able to present data for each day. Next, you will need to do a count calculation where you count the number of days within a given month. You would need something like allcount(d1, all(s), m1) if you days are part of a month-day hierarchy. This is the only way to know how many days has passed within the current month, based on client-only calculations.
BR / Ole
|
Ole Dyring |
|
|
|
|
|
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.