a previous admin created a very complicated script for CLV to generate the value, but it only ran when the customer record was viewed - so reports have inaccurate data.