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

    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