5 Replies Latest reply: Apr 9, 2015 1:47 AM by James Kerrigan RSS

    Set analysis in load script

    James Kerrigan

      Hey guys,

       

      I'm trying to look at the increase in Annual Fees between two years by calculating it in the load script. I want to do it in the load script because I need to do set analysis on it as well.

       

      I have a field named 'Annual_Fee' and a field 'Fee_Fiscal_Year' and basically I'm trying to seperate the 2014/2015 and 2013/2014 years and calculate the difference.

       

      I'm trying to do this in the load script:

      Sum({$<Fee_Fiscal_Year = {'2014/2015'}>}Annual_Fee) - Sum({<Fee_Fiscal_Year = {'2013/2014'}>}Annual_Fee) as "Increase $"

       

      But it's not working because of the curly brackets. Do you guys know how I can get around this?