12 Replies Latest reply on Nov 14, 2016 6:14 AM by Andrew Teer

    Forecasting with dynamic formating of labels ($M vs $K etc.)

    Andrew Teer

      Hi everybody,

       

      I apologize if this is a rudimentary question, but I have not been able to find anything in the forums yet.  I am trying to do a full year forecast that has a dynamic label that will show in Millions or thousands or not whenever appropriate. I have found a trick that uses three calculated fields to accomplish this.  However, whenever I drag them onto label, the forecast disappears.

       

      I have attached a workbook using Superstore that shows my basic issue.

       

      Any thoughts?

       

      Thanks in advance!