Good day:
I have an app that records partner payments. Every time a member pays a fee or several, I select it from an enumlist that refers to a table where the months are found.
Here comes my question:
Is there a way that when selecting a partner the enumlist only shows the months that remain to be paid?
Cannot be sure of the exact expression without knowing your architecture but it would be something like the following in the Suggested Values.
MONTH TABLE[month]
-
UNIQUE(
SPLIT(
SELECT(
PAYMENT TABLE[MONTHS ENUMLIST],[PARTNER]=[_THISROW].[PARTNER]
),
" , "
)
)
User | Count |
---|---|
18 | |
11 | |
7 | |
3 | |
2 |