Photo by Sigmund on Unsplash
“not operator along with the custom named condition operators is not allowed”
Operator <> or NOT In. In and Exactin
For example in an Items of Gallery :
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
| With(
{
userlevel_isnot_banker: First(colSession).UserLevel <> "Banker",
isnotteamhead: First(colSession).CurrLevel <> "RO",
isnotbanker: First(colSession).CurrLevel <> "Banker",
ro: First(colSession).CurrTeam,
banker: First(colSession).CurrBanker,
},
Filter(
WAM_Trade_Summarizes,
FinalDate_yyyymm in ComboBoxTradeFinalDate.SelectedItems,
(isnotteamhead || RO_gb=ro),
(isnotbanker || GroupBanker_gb=banker),
(userlevel_isnot_banker || (
Statement_prod_type_gb <> "Extra Rate" &&
Statement_prod_type_gb <> "Management fee" &&
Statement_prod_type_gb <> "Error"
))
)
)
|
Use this
1
2
3
4
5
| (
Statement_prod_type_gb <> "Extra Rate" &&
Statement_prod_type_gb <> "Management fee" &&
Statement_prod_type_gb <> "Error"
)
|
instead of
1
| !(Statement_prod_type_gb in ["Extra Rate", "Management fee", "Error"])
|
or
1
| Not(Statement_prod_type_gb in ["Extra Rate", "Management fee", "Error"])
|