4 Replies Latest reply: Mar 26, 2013 11:14 AM by Borys Pastuszek RSS

    Expression problem

    kosta christopher

      Hi all,

       

      I am trying to get the sum of "Supply OG" where it does not take into account the year selected and only displays that of "Saurian Petroleum"

       

      Here is my expression, when I just have the year section it works but shows all companies and when I add in the Saurian Petroleum section it only returns the values of Saurian but now also only returns the values for the currently selected year.

       

       

      Sum

      ( {<Year=>} {$<Company={[Saurian Petroleum]}>} [Supply OG])

       

       

      I am assuming there is a proper way to connect the two modifiers but I do not know the code.

       

      Hopefully someone can help me.

       

      Thanks,

      Kosta