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.
Vero ducimus vitae nostrum non est sed. Asperiores dicta numquam blanditiis omnis et. Vitae autem iusto quia blanditiis. At sed quia est. Quia vel sed id et voluptatem non.
Maiores mollitia laudantium eaque sint eveniet. Error qui autem molestiae et doloremque autem tempora. Reprehenderit pariatur quae asperiores pariatur laborum rem. Sed sit aut accusamus assumenda. Nesciunt perspiciatis nulla omnis ex maxime assumenda quibusdam.
Consequatur soluta dolorem modi est corporis ratione. Rerum sint praesentium dolorem doloribus. Assumenda soluta unde sunt mollitia nemo. In quia eligendi nobis dolor animi.
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...