Forum Discussion
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. ...
I feel like this could be a SUMX thing. So, instead of calc = amt1 + amt2 - amt3, try calc = SUMX( Movimientos, amt1 + amt2 - amt3 )