Hi,
What is the right expression to allow me to edit the [Name] column?
This expression in valid if is what I am using to limit the name and remove in the list what is already on the list.
All works well until I edit and it is throwing invalid entry. Please assist.
(
SELECT(
Dipstick[Pump 1 Attendant],
AND(
([Date] >= [_THISROW].[Date Start]),
([Date] <= [_THISROW].[Date End])
)
),
+ SELECT(
Dipstick[Pump 2 Attendant],
AND(
([Date] >= [_THISROW].[Date Start]),
([Date] <= [_THISROW].[Date End])
)
)
+ SELECT(
Dipstick[Cashier],
AND(
([Date] >= [_THISROW].[Date Start]),
([Date] <= [_THISROW].[Date End])
)
)
)
-
Select(Salary[Name],AND(
([Date Start] >= [_THISROW].[Date Start]),
([Date End] <= [_THISROW].[Date End]),True))
Maybe the below, even though not tested it. Changes highlighted in bold.
IFS(
ISBLANK( FILTER( โSalaryโ, AND([_THIS] = [Name] ,([Date Start] >= [_THISROW].[Date Start]),
([Date End] <= [_THISROW].[Date End]) ) ) - LIST([_THISROW])) ,
(
SELECT(
Dipstick[Pump 1 Attendant],
AND(
([Date] >= [_THISROW].[Date Start]),
([Date] <= [_THISROW].[Date End])
)
),
Select(Salary[Name],AND(
([Date Start] >= [_THISROW].[Date Start]),
([Date End] <= [_THISROW].[Date End]),True)),
FALSE
)
Based on the expression mentioned at the last on avoiding duplcates in the article below
Iโll Check Suvrutt and revert. Thanks so much.
Thank you. Yes, please do revert.
User | Count |
---|---|
37 | |
31 | |
29 | |
22 | |
18 |