"I have a transaction form like the following,
The problem is I only want to display the months that have not been paid, currently it still displays the entire month selection
And in the form that currently exists, I only managed to give a valid error if the month period has been paidโ
In the Valid_If expression of the [Pembayaran Bulan] column, you will want to SUBTRACT the list of months paid from the list of all months. Since you already have a column reflecting the months paid, this is fairly straight forward using the โlist subtractionโ operator like so:
LIST("Jan", "Feb", "Mar", "Apr", "May", "Jun",
"Jul", "Aug", "Sep", "Oct", "Nov", "Dec")
-
SELECT(TABLE[Pembayaran Bulan],
AND([Kode Langganan] = [_THISROW].[Kode Langganan],
[Jular] = [_THISROW].[Jular]))
+ [_THISROW].[Pembayaran Bulan]
Note: I guess at the table selection criteria. You may need to adjust it to select the desired rows.
The โ+โ adds back the month for the current row as a valid value. May not be necessary but it doesnโt hurt.
thanks for the feedback, Iโm not sure where the error is, but Iโm really glad you can help again
What is the defined type for column [Pembayaran Bulan]?
Yes, right,
??? I was asking for the definition type of the column.
for the problem above has been resolved properly, with the formula given without the +. thank you I say
but now there is 1 new problem, where i want to do validation, showing only [Kode Pelanggan Full] and [Pembayaran Bulan]
with criteria, column [Jan] to [Dec] is empty
To select rows where ALL months are empty, you will need to check each of the month columns like so:
SELECT(TABLE[Kode Pelanggan Full], AND(ISBLANK([Jan]), ISBLANK([Feb]),...,ISBLANK([Dec]))
NOTE: Fill in the rest of the months where the โโฆโ is!
oke thanks
Hi, I want to continue the discussion again.
can list subtraction work with subtracting data with enumlist option,
like this for example:
Yes, it should work just fine. Give it a try!
but data with enumlist results like this: Oct,Nov,Dec
not to be deducted from list data : LIST(โJanโ, โFebโ, โMarโ, โAprโ, โMayโ, โJunโ,
โJulโ, โAugโ, โSepโ, โOctโ, โNovโ, โDecโ)
any suggestions?
I donโt understand. What is the end result you are hoping to get back?
i want data " Oct,Nov,Dec ",
can already be a deduction from the data list,
but this only works when the data contains only examples of "Oct " or โNovโ only, canโt combine data like "Oct,Nov,Dec "
If your column is an EnumList and it has the value list of โOct, Nov, and Decโ
You should be able to to perform a LIST subtraction like so:
LIST(โJanโ, โFebโ, โMarโ, โAprโ, โMayโ, โJunโ,
โJulโ, โAugโ, โSepโ, โOctโ, โNovโ, โDecโ) - [EnumList Column Name]
And end up with the result of:
โJan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sepโ
Is that not what you see happening? If not, what IS happening?
I use valid data, valid if =
or(
IN([Path],Select(user[path],usersettings(level)=โAdminโ));IN([Path],Select(user[path],[Name]=[_THISROW].[Sales Name], usersettings(level)=โUserโ))
)
but the column shows only 1 item, and it doesnโt match.
Whereas if I use valid if =
Select(user[path],[Name]=[_THISROW].[Sales Name],usersettings(level)=โUserโ)
Columns can display appropriate options.
in this condition I want to do a multiplication , if Ex. A then must use the formula A, and the result belongs to A while if Ex. B then you have to use formula Bโฆ how is the valid if formula that can work, hopefully someone can help, Iโm very grateful
Your expression has a semi-colon in it instead of a comma.
Also for User/Admin, you probably want to use the USERROLE() function but this only works if you are white-listing the users in the app.
Yes thatโs right,
thatโs the result I want.
and I combine this formula like this, the result is not as above.
LIST(โJanโ, โFebโ, โMarโ, โAprโ, โMayโ, โJunโ,
โJulโ, โAugโ, โSepโ, โOctโ, โNovโ, โDecโ) -
SELECT(Transaction[Payment Month],and(YEAR([Date])=YEAR(TODAY()),[Subscription Code]=[_THISROW].[Subscription Code],or(isnotblank([Subscription Status]),isnotblank( [Amount])))
)
Maybe there are inputs and suggestions from my formula above?
in the [month payment] column, the โJanโ value should not be displayed again
This expression looks ok. Have you tested the SELECT() to make sure it is returning the list of values you expect?
yes, this expression works, but only for inputs like โJanโ, not for โJan,Febโ
Looks like the attached photo,
results are not as expected.
no list is deducted from the input process
User | Count |
---|---|
43 | |
29 | |
24 | |
21 | |
13 |