I would like to add a Slice from a datatable "Jobs"
The Row filter condition must be ==> [Email]=Useremail() <==
The problem is that my column [Email] is not in the datatable "Jobs" but in the datatable "Responsibles"
Thanks
How your tables Reponsibles and Jobs are linked then ?
In Jobs I have a column RespName (type Name) which is set as Key.
In Resp I have a column RespName (type Ref) and a column Email (type Email) set as Key.
In Jobs I add a virtual column Email (type List) with formula ==>Ref_Rows("Resp","RespName")<==
I create a slice in Jobs with Row filter condition =[Email] = useremail()
I receive an error: "Cannot compare List with Email in ([Email] = USEREMAIL())"
When I change the column Email (in Jobs) then we have the error:
The type of the app formula 'List of Ref to table 'Resp' of Email' does not match the column type 'Email'.
Thanks
User | Count |
---|---|
35 | |
30 | |
30 | |
20 | |
18 |