2 Replies Latest reply: Mar 31, 2017 4:52 AM by Jörgen Marcusson RSS

    Set analysis, equal to another field

    Jörgen Marcusson

      Hi!

      I'm trying to sum "Budget_cost" for projects that in the same table have "Rev_no" equal to field called "Rev_no_actual" in another table.

       

      I thought it would look like this but it doesn't work. I get 0,00 as result.

       

      Sum({$<Rev_no={'Rev_no_actual'}>}Budget_cost)

       

      Do anyone have any suggestion?