Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
There Straigh Table 8 rows by 8 columns.
In each row and column information from its database
Column 1 - field Fp - just a list from 1 to 8
F_prm and R_prm taken from the base value of from 1 to 8.
No matter how trying to use a subset of Expression , I can not substitute the value of Fp or RowNum () inside the set.
We have to use such a misery, listing line number (Fp), and if it means 1, the inside of the set to expose 1, 2 -> 2, etc. nt ({$ <F_prm = { 1 }, R_prm = {8}> } DISTINCT Client)
if(Fp=8, Count({$ <F_prm={8}, R_prm={8}>} DISTINCT Клиент)))))))))
- if (Fp=1, Count({$ <F_prm={1}, R_prm={8}>} DISTINCT Клиент),
- if(Fp=2, Count({$ <F_prm={2}, R_prm={8}>} DISTINCT Клиент),
- if(Fp=3, Count({$ <F_prm={3}, R_prm={8}>} DISTINCT Клиент),
- if(Fp=4, Count({$ <F_prm={4}, R_prm={8}>} DISTINCT Клиент),
- if(Fp=5, Count({$ <F_prm={5}, R_prm={8}>} DISTINCT Клиент),
- if(Fp=6, Count({$ <F_prm={6}, R_prm={8}>} DISTINCT Клиент),
- if(Fp=7, Count({$ <F_prm={7}, R_prm={8}>} DISTINCT Клиент),
Maybe somehow we can make Expression one line:
Count({$ <F_prm={1}, R_prm={8}>} DISTINCT Клиент)
and instead F_prm = { 1 } or substituted RowNum () or Fp?
Construction (and a lot of different or similar)
Count({$ <F_prm={$(RowNum())}, R_prm={8}>} DISTINCT Клиент)
Count({$ <F_prm={$(Fp)}, R_prm={8}>} DISTINCT Клиент)
Count({$ <F_prm={Num(Fp)}, R_prm={8}>} DISTINCT Клиент)
do not pass
It sounds like your data model should be modified, but I don't know what it looks like and to be honest I don't understand what you're trying to do. Perhaps this document helps: Evaluating "sets" in the context of a dimension