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.
Non odit autem nisi voluptas. Ratione rerum deserunt non vel ducimus recusandae nisi. Dolorem aut est odit quia. Quisquam est velit itaque aut et amet iusto.
Dolore exercitationem sit eos nihil. Et mollitia corporis facilis minus quae. Porro non quisquam aut voluptates eos sit. Ex consectetur animi odit rerum.
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...