Forum Discussion

superjam's avatar
superjam
Icon for Helper II rankHelper II
2 years ago

Problems with a YTD calculation

Hello.   I have three tables: 1. Movimientos, among others, with the following columns: - date - amt1 - amt2 - amt3 There may be multiple lines for the same date, with different amt values. ...
Need Help
CoreyP's avatar
CoreyP
Icon for Solution Sage rankSolution Sage
2 years ago

I feel like this could be a SUMX thing. So, instead of calc = amt1 + amt2 - amt3, try calc = SUMX( Movimientos, amt1 + amt2 - amt3 )