rodwhiteley
New Member
- Joined
- Jan 15, 2012
- Messages
- 37
Hey guys,
I have a reasonably big table which is being used in part to count events (think of them like sales) occuring on days. Internally we want people to achieve 10 of these per day, so I created a measure being 10-[Sales], but it appears to be calculating incorrectly intermittently.
As a proof of concept for the analysis I'm building, the formula for [Capacity] is simply 10-[Male Daily New Adjusted], and you'll see instances here where it is calculating incorrectly by one intermittently (all of the highlighted items don't add up to 10 as they should)
Clearly I'm going something wrong here - any thoughts?
Rod
I have a reasonably big table which is being used in part to count events (think of them like sales) occuring on days. Internally we want people to achieve 10 of these per day, so I created a measure being 10-[Sales], but it appears to be calculating incorrectly intermittently.
As a proof of concept for the analysis I'm building, the formula for [Capacity] is simply 10-[Male Daily New Adjusted], and you'll see instances here where it is calculating incorrectly by one intermittently (all of the highlighted items don't add up to 10 as they should)
Clearly I'm going something wrong here - any thoughts?
Rod