2 Replies Latest reply on Dec 18, 2017 11:34 AM by Matt Lutton

    Extract values from Total table calc

    shwetha sarma

      Hello,

       

      I'm working on a calc which is based off of the (sum of total) of another value.

       

      I want to extract the total number and use it for a different calc field. Attached is the sample workbook. Please let me know if it is possible.

       

      Inforce calc is working based on 3 calc fields and index function and sum(inforce) is what I want to use for new calc.

       

      For my new calc, I want to take the (total inforce number) * (another measure).

       

      I hope I explained it well. Please let me know if you have any questions.

       

      Thanks,

      Shwetha.