3 Replies Latest reply: Apr 15, 2015 4:30 PM by Ola Amphan RSS

    Using row value in set analysis

    Ola Amphan

      Hi,

       

      I'm stuck at problem where I want sum an amount based on on a value in a field per row. Please see the attached app and picture.

       

      If I hardcode the value as sum({<row_number = {2}>} total amount) it works but when I try to use the contents of a field (per row) it fails.

       

      Can anyone help me find a solution? It does not matter if it is set analysis or if statements. I just want to be able to sum based on other rows than the current. I will use it to make calculations based on the sums of the different rows. For example, if(row_number=3, sum(row1)/sum(row(2)).

       

      image.png

       

      TIA

       

      //Ola