I have a table that gives/shows Accounts receivable (AR). In my app i show AR based on day ranges:
31 - 60
I am trying to now get the total PER day range and show that.
I used this expression:
SUM(select(AR[90 + Days Virtual], [Customer Number] = [_THIS].[Customer Number]))
This is [90 + Days Virtual]:
(TODAY() > ([Document Date] + 90)),
[Current Trx Amount]
Here is what the expression gives me in my app:
If you manually calculate this it is wrong. I am not sure why.
I must note I filter this slice taking out:
“Credit Memos” and “Payments”
AND( [Document Type] <> “Payments”, [Document Type] <> “Credit Memos”)
I looked at the raw data - and no where in “Payments” nor “Credit Memos” is there a value that would match the difference. Meaning I believe the slice filter is working correctly by taking out “Payments” and “Credit Memos”.