Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the following expression in a text box.
=sum([NS D1 Desk])
+sum([NS D1 Facilities])
+sum([NS D1 Hours])
+sum([NS D1 HRBP])
+sum([NS D1 Induction])
+sum([NS D1 Inductionmeeting])
+sum([NS D1 Introduced])
+sum([NS D1 Login])
+sum([NS D1 ManualHandling])
+sum([NS D1 Officetour])
+sum([NS D1 Password])
+sum([NS D1 Reception])
+sum([NS D1 Uniform])
Is there a way to use a wildcard to have it something like
=sum([NS D1 *])
For reference, the data looks something like
Name ND D1 Desk NS D1 Facilities NS D1 Hours .........
Adam 1 0 1
Betty 1 1 0
Carl 1 1 1
Denise 0 0 1
:
:
So the answer in this made up example would be sum([NS D1 *]) = 8
Thanks,
Karl
So, I tried this
Table:
LOAD * INLINE [
Dim, 2016, 2017
A, 20, 40
B, 30, 65
];
STORE Table into Table.qvd (qvd);
DROP Table Table;
Table:
CrossTable(Year, Value)
LOAD *
FROM Table.qvd (qvd);
Gave me this
While this worked without any issues
Table:
LOAD * INLINE [
Dim, 2016, 2017
A, 20, 40
B, 30, 65
];
STORE Table into Table.qvd (qvd);
DROP Table Table;
Table:
CrossTable(Year, Value)
LOAD *
FROM Table.qvd (qvd)
Where 1 = 1;
Yeah, orphans all over the place. You really don't want that in your data model.
Still the same as it used to be.
Thank you, this worked perfectly