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. ...
Hi CoreyP
Thank you for your help. The SUMX thing actually worked, ...in part.
The YTD calculation is now correct. This part is corrected!!
But, now a little problem appeared in the calculation for the "calc" measure: if some values of amt1, amt2, or amt3 is blank, then the end result is also blank.
I suppose this happens, because for some months, there is no register for some amt values. I mean, for example, there is no line of february with amt2.
Is there a way to correct this?
Thank you again and regards.