1 Reply Latest reply on Mar 16, 2018 12:42 PM by Wes Reneau

    Aging Values

    Slav Maslyanchuk

      I would like to make a calculation that would do what the image is describing is this even possible?

      Capture.PNG

       

      Added the workbook.

      To clarify I need to take the numbers from the three columns circled and ad the values of the calculations to the current and 1-30 based on percentages specified above. while keeping the same view.

        • 1. Re: Aging Values
          Wes Reneau

          Yes, you could do it with some calculated fields. You'll probably need if/then logic since you have a dimension on your columns shelf (if aging date = '31-60' then value * .25......). If you attach a workbook with dummy data, someone will most likely be able to help with exact steps.

           

           

          -W