Forum Discussion
Can you tell us what the result is when you simply average the value of the $Sale value?
var number Sale = If(not IsNull([Agreement Signed]) and ToDate([Agreement Signed]) >= Today() - Days(30) and [Sales Agent Name] = "Agent Name", 1, 0);
$Sale
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Hiya Mark,
The average value for just $Sale comes to 0.16%
The amount of Sales has increased since the initial calculation.
Sale = 126 and NoSale = 302
------------------------------
Nick Green
------------------------------
- MarkShnier__You9 months agoQrew Legend
You say that the report filter is only where the Agreement Signed is not null.
I return the records for the last 30 days where the Agent is assigned and the Agreement Signed is not null,
But the formula for NoSales is
var number NoSale = If([Sales Agent Name] = "Agent Name" and IsNull([Agreement Signed]), 1, 0);
Doesn't that mean that NoSale will always be zero?
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------- NickGreen9 months agoQrew Member
For the NoSale I return all the records where the agent is assigned and the but the Agreement Signed is null.
For the Sale I return all records for the last 30 Days where the agent is assigned and the Agreement signed is not null, so effectively it excludes all records where the agent is assigned and the Agreement Signed is not null, to get an accurate value of their current conversion of those records that still need to get the customer on boarded.
I've not set an actual filter on the report, I am letting the formula do the lifting in this case.
So at the moment it is returning actual values, they just appear to be skewed.
------------------------------
Nick Green
------------------------------- MarkShnier__You9 months agoQrew Legend
I suggest that you either use three report formulas on a table report to calculate Sale, No Sale and conversion rate, or else make three real fields and expose them on a tab;e rpeort to see whats going on.
But you say that you have no filter on the report. Do you have records on the report where the Agent name is not "Agent Name". It seems to me that you need to add that Filter.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------