Yearly Capital Gain Discrepancy

PeterO

I have a discrepancy in capital gain figures in different tables/worksheets.
In Monthly worksheet, Grand Total column/row cell I have a figure X. It matches with Holdings table Capital Gain/Grand Total cell using 2020 filter. But it is different to Yearly worksheet, Yearly Movements table, Capital Gain/2020 cell. Shouldn't they be the same?

VidasMatelis

Peter,

Different worksheets have different filters on symbols. Holdings table shows just symbols that are currently "holding" and total capital gain will include just these symbols. Yearly worksheet does not have same filter, so it will include all symbols, for example if symbol was sold in 2020, it will not be included in Holdings, but included in Yearly. Would that explain difference?

PeterO

Right again Vidas. I should have looked at filters before asking, especially in light of my previous question which was kind of related... Anyway, many thanks!