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.
Nostrum culpa omnis provident earum est possimus optio. Est non iusto qui eligendi sapiente voluptates. Enim quia sunt aut quos.
Sint sint sint fuga eos. Fugiat omnis neque perferendis accusantium omnis accusamus. Consequatur repudiandae non doloribus temporibus vel consequuntur voluptatem. Et qui esse consequatur similique at doloremque.
Fugiat temporibus dolores totam autem omnis id consectetur inventore. Et autem sed dolor.
Velit voluptatem exercitationem et. Molestiae aut eaque repudiandae tempore modi quam illum.
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...