7 Replies Latest reply on Aug 8, 2013 5:26 PM by Jonathan Drummey

    Calculated fields become invalid on replacing data source

    Aishwarya Balamukundan

      Hi All,

       

      I am facing a problem to which I cannot find the cause thereby I can't find the solution . So here it goes:

       

      I have created calculated fields -

      Total BilledFY13 -

      IF [Fiscal Year] = 2013

      THEN [TOTAL BILLED (CC $)]

      ELSE NULL END

       

      Similarly for FY14. I'm finding the difference and basically coming up with a waterfall chart.

       

      Every week the data source needs to be replaced with a new one, all fields are named the same. Week 1 data needs to be replaced with week 2 , and so on. I've noticed that any calculated field I create with an IF statement becomes invalid when I replace the data source.

       

      Any light on what exactly is happening or solution would really help! Thanks for your time people !

       

      Regards

      Aishwarya