Solved: I cannot figure out why my value (from expression)... - Page 2

Tiger1 · 03-02-2020 11:01 AM

I have a table that gives/shows Accounts receivable (AR). In my app i show AR based on day ranges:

0 -30
31 - 60
61 -90
90+

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]:
IFS(
(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”.

Bahbus

So, that is why I asked my very first question. You are using a slice view the filters out Payments and Credit Memos from the table AR. But your expressions themselves operate on the ENTIRETY of the AR table. Slices don’t change the way expressions work on the underlying data.

SUM(
    SELECT(AR[90 + Days Virtual], 
        AND([Customer Number] = [_THIS].[Customer Number],
            [Document Type] <> “Payments”,
            [Document Type] <> “Credit Memos”
        )
    )
)

View solution in original post

I cannot figure out why my value (from expression) is wrong