1 Reply Latest reply: May 21, 2015 3:19 AM by Gysbert Wassenaar

# for each row want its value

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=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 Клиент),

if(Fp=8, Count({\$ <F_prm={8}, 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