2 Replies Latest reply: Oct 9, 2017 4:08 PM by Helge Jørgensen RSS

    Expression with filter on year at the same time as year 2015 is fixed

    Helge Jørgensen

      I hope that some of you can help with setting up an expression that makes it possible to filter on year at the same time as 2015 is fixed within the expression.

       

      I have a dataset where I would like to subtract sum of remaining oil eq from a selected year, from sum of remaining oil eq at 2015. Year 2015 needs to be fixed, and I need to be able to select the first year by filtering.

       

      I have tired with several expressions, with no success so far. Hopefully some of you can help me!

       

      Sum({<[ReserveHistory.Year]>}[ReserveHistory.Remaining mill Sm3 o.e])

      -

      Sum({<[ReserveHistory.Year]={2015}>}[ReserveHistory.Remaining mill Sm3 o.e])

       

      Cheers

      Helge