Hi,
I am trying to achieve the following output:
There are 14 accounting periods, therefore the formula about End YTD looks like this: Sum({$<[Accounting Period (F)]={"<$(=Floor($(vYTD_YearMonth),100))"}>+<[Accounting Period (F)]={">$(=Floor($(vYTD_YearMonth),100))<=$(vYTD_YearMonth)"}>}[Debit in EUR (F)])
-
Sum({$<[Accounting Period (F)]={"<$(=Floor($(vYTD_YearMonth),100))"}>+<[Accounting Period (F)]={">$(=Floor($(vYTD_YearMonth),100))<=$(vYTD_YearMonth)"}>} [Credit in EUR (F)])
How can I define the End YTD 1, so it could be filtered flexible as well?
Thanks in advance!