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




      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 !