0 Replies Latest reply: Apr 16, 2014 8:16 AM by James Phillips RSS

    Prior Year missing Revenues

    James Phillips

      All, I have 5 products with revenue last year, and this year only for of them have revenue. When comparing this years revenue vs last years revenue, I am receiving the proper grand total, however the product shows up but the revenue is blank?... any ideas?

       

       

      ({$< Year= {$(= GetFieldSelections(Year)-1)},[Calc.Type] -= {'Forecast*'},Date={"<=$(=vMaxDate)"}>}[Amount])/Factor

       

      help.jpg