Hi,
I have an issue when it comes to summarizing in a module, and using Last-non blank.
I have two lists, L1 (units) and L2 (transactions for the parent unit). I then have a module where I have L2 as dimension and a number of line items.
All transactions contains a valid from date, which I sort by in the module (only sorting on L2 level). Then, for all line items, I have set the summary as "Last non-blank" and hence want the L1 to show the values from the latest added transaction, if that value isn't blank. If it is, then it should look at the transaction with the second most recent valid from date and so on.
This used to work perfectly fine, but it seems that without me changing anything, the module ignores my sorting, and simply take the last non-blank based on transaction ID.
How it is (wrong)
Level | ID | Valid From (sorting) | Line item 1 | Line item 2 |
L2 | #1 | 2019-01-01 | A | 1 |
L2 | #3 | 2019-01-02 | B | 2 |
L2 | #2 | 2019-01-03 | C | 3 |
L1 | Unit1 | 2019-01-02 | B | 2 |
How it should be
Level | ID | Valid From (sorting) | Line item 1 | Line item 2 |
L2 | #1 | 2019-01-01 | A | 1 |
L2 | #3 | 2019-01-02 | B | 2 |
L2 | #2 | 2019-01-03 | C | 3 |
L1 | Unit1 | 2019-01-03 | C | 3 |
Since this used to work, and I haven't changed anything, I don't really know how I would go about to solved this. It seems like the module simply ignores my sorting on "Valid From"...
Any help is highly appreciated!