06-03-2019 03:58 AM
06-03-2019 06:57 AM
06-03-2019 07:56 AM
@FrancescoBarcelona Hi Francesco, I know what is happening
The problem is that the serie that generates the tendency has filled out with zero until end of year, so the tendency is showing that, to solve this you have to empty the rest of the year, so the tendency only get calculated over the real data. Try that and let me know if works
06-04-2019 08:09 AM
@FrancescoBarcelona Hi Francesco, I'm not an expert so I cannot tell you that's the definitive solution, but, based on how the tendency line is calculated, I think it is. Remember that zero's affect the calculation.
You can use a IF function to ask if there is a data for a specific cell, if true you put the formula if don't you put "blank" maybe that could help you.