Trumpetbob

Discussions

Help with a complex calculation that isn't working in Beast Mode.
I am trying to calculate a comparison of an individual's performance compared to the established average. This is for setting appointments. The appointment conversion ratio is found by (appointments set / number of contacts). The appointment conversion ratio / average gets the performance multiplier. 1 being average, 2…
Rolling Percentage
I want to have a rolling percentage of a value across a series of values. I want to be able to choose the value and the size of the series. Here is an example where I want to know the percentage of Oranges for the last 5 values. Also, Is it possible to do a running percentage of the value? Just thought of that. Ideally I…