Exclude Zeros in Time Sum Average

Options
nawalker56
nawalker56 Member, ALL USERS Posts: 2 New Contributor
in Planning & Modeling

Hi,

I am using a TIMESUM average and I'm wondering if there is a way to exclude zeros from the average. Formula: TIMESUM(Build Factor, TIME.'Q2 FY16', TIME.'Q4 FY19', AVERAGE) Pictures attached.

Tagged:

Comments

  • bhubeshrana
    bhubeshrana Member, ALL USERS, Certified Model Builder Posts: 5 Contributor

    set format to 0 decimal places

    bhubeshrana_0-1634125355987.png

     

    and if still you want to hide the zero values then apply filter >0.

     

Categories