Re: Diferentes resultados de YTD - Script x Expressão - Pq?

If one of the five columns are null the YTD will be Null if you use JAN+FEV+MAR+ABR+MAI. But rangesum will sum all non-null values.

Example:

JAN    FEV    MAR    ABR    MAI    JAN+FEV+MAR+ABR+MAI    RangeSum(JAN, FEV, MAR, ABR, MAI)

10        Null()    10        10        10          Null()                                        40

10        10        10        10        10          50                                            50

On the front end Sum(JAN) + Sum(FEV) + .... make Sum(Null()) = 0 not causing any issue.