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

    Extract values from Total table calc

    shwetha sarma



      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.