Customer Data Analysis - Handling Negative Values?
Does anyone know the best way to deal with negative values when conducting cohort analysis on revenue data? Feel like I'm going to have to write some lengthy formulas so that churn, expansion and downsell aren't skewed. Do others simply strip out these values?
Negative values of revenue data? As in you are paying the customer? I don't see how that could be possible unless you are attaching a bill rate to a services business or are a ZIRP business giving away more money to customers than actually gets booked as revenue.
Yep. It’s data received from the sellside on a recurring revenue business. No footnotes provided as to what it could mean. I wrote a formula to handle those instances but am now just curious if anyone has encountered and what this represents.
Commodi repellat veritatis tempore delectus sed error. Sit qui impedit consequatur ducimus error tenetur. Non alias reprehenderit minus quia ducimus.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...