5 Replies Latest reply on Jan 12, 2016 2:51 PM by bidyadhar swain

    Problem with Division

    bidyadhar swain

      Hello,

      I am trying to calculate Schedule Variance for which I am using formula like this but it is not working

      (Total Completed task-Task completed with +variance)/Total Completed task

       

      Total Completed task is derived as -------

      Count([Projects])-which is count of Dimension Object project

       

      Task completed with +ve variance is derived as --

      IF [Is Schedule Variance +ve ?]='Yes' Then 1 else 0 END

       

      Can you please suggest me if anything I need to do

       

      This is excel source trying to create dashboard in Tableau

      Regards

      Bidy