For MYL, both CapEx(0,TTM,KeepNA) and CapEx(1,TTM,KeepNA) are positive.
What’s happening is since DivPaid(0,TTM,KeepNA) is NA, the FCF expression is falling back to the prior period.
Given FCF=OperCashFl-CapEx-DivPaid
Without Fallback,
OperCashFl(0,TTM,KeepNA)-CapEx(0,TTM,KeepNA)-DivPaid(0,TTM,KeepNA) = 1680.2 - 274.5 - NA = NA and FCFTTM(0,TTM,KeepNA)=NA // match!
OperCashFl(1,TTM,KeepNA)-CapEx(1,TTM,KeepNA)-DivPaid(1,TTM,KeepNA) = 2341.7 - 252.1 - 0 = 2089.6 and FCFTTM(1,TTM,KeepNA)=2089.6 // match!
With Fallback,
OperCashFl(0,TTM)-CapEx(0,TTM)-DivPaid(0,TTM) = 1680.2 - 274.5 - 0 = 1405.7 and FCFTTM(0,TTM)=2089.6 // mismatch!
I think I’m going to start using my own FCF expression. Perhaps something like;
isNA(OperCashFl(0,TTM,KeepNA)-CapEx(0,TTM,KeepNA)-isNA(DivPaid(0,TTM,KeepNA),isNA(DivPaid(1,TTM,KeepNA),NA)),OperCashFl(1,TTM,KeepNA)-CapEx(1,TTM,KeepNA)-isNA(DivPaid(1,TTM,KeepNA)))
If the current period DivPaid is NA, it will use the prior period value. If that’s NA or if the current period OpercashFl or CapEx are NA, then it will fallback all the component values.