4 Replies Latest reply on Aug 28, 2018 6:10 PM by Shinichiro Murakami

    Date Calcs

    Barb Reiser

      I need to figure out how to calculate a couple of things and then combine them into one formula:

       

      1. The current day. For example, today's the 28th, I want it to say 28.

      2. The total # of days in the month. It's August, so I want it to say 31.

       

      I tried starting the calc under the measure "Pace", using the Dimension "Current Day", using the Today() calc, but it tells me that I can't divide a float value by date value. Not sure how to fix that. My calc for total # of days in the month is way wrong too.