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

    Problem with Division

    bidyadhar swain


      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