3 Replies Latest reply: Apr 15, 2014 11:12 AM by Paul Gelardi RSS

    Data is not showing as a percentage

    Paul Gelardi

      I'm looking at a report setup by someone else and I can't figure out why the data for "Plan Rate" is showing as 0.03 instead of 3.0%

       

      Below is the definition of the expression called "Plan Rate"

       

       

      (sum({$<//PlanYear={$(=max(Year))},

      Year={$(=max(Year)-1)},

      DepartmentNo={80},

      StoreStatus={'Board Comp'},

      CompletePeriodFlag={1}

      >}

       
      NET_SALES * (1 + if(isnull([Target Growth %])=-1,0,[Target Growth %])))

      /

      sum({$<//PlanYear={$(=max(Year))},

      Year={$(=max(Year)-1)},

      DepartmentNo={80},

      StoreStatus={'Board Com'},

      CompletePeriodFlag={1}

      >}

       
      NET_SALES)-1

      > 0,

      sum({$<//PlanYear={$(=max(Year))},

      Year={$(=max(Year)-1)},

      DepartmentNo={80},

      StoreStatus={'Board Comp'},

      CompletePeriodFlag={1}

      >}

      NET_SALES * (1 + if(isnull([Target Growth %])=-1,0,[Target Growth %])))

      /

      sum({$<//PlanYear={$(=max(Year))},

      Year={$(=max(Year)-1)},

      DepartmentNo={80},

      StoreStatus={'Board Comp'},

      CompletePeriodFlag={1}

      >}

      NET_SALES)-1)

       

       

      I looked at the Number Format Settings and it seems correct:

       

      Plan Rate Number Format Setting.jpg