locked
Can a calculated value be based upon existing calculated value fields? RRS feed

  • Question

  • So I would like to confirm something. Can I have a calculated value be based upon existing calculated value fields? Example....

     

    Qty   Amount   Total

     

    Sub Total

     

    Total would be a calculated field (qty * amount) and then would like to sum all of the totals and have that be the sub total.

     

    Appreciate your help.

     


    Kipp Sorensen
    • Split by Mike Walsh FIN Friday, April 1, 2011 4:08 AM new question in long closed thread in InfoPath forum
    Thursday, March 31, 2011 11:15 PM

Answers

  • I figured out what my particular issue was and figured I better share in case it isn't clear for others. So to calculate totals off existing calculated amounts you need to make sure the controls stay as textboxes and not "calculated values". Once I did that then all my calculations worked fine

    Kipp Sorensen
    • Proposed as answer by KBES Thursday, March 31, 2011 11:30 PM
    • Unproposed as answer by Mike Walsh FIN Friday, April 1, 2011 4:06 AM
    • Marked as answer by Mike Walsh FIN Friday, April 1, 2011 4:15 AM
    Thursday, March 31, 2011 11:30 PM

All replies

  • I figured out what my particular issue was and figured I better share in case it isn't clear for others. So to calculate totals off existing calculated amounts you need to make sure the controls stay as textboxes and not "calculated values". Once I did that then all my calculations worked fine

    Kipp Sorensen
    • Proposed as answer by KBES Thursday, March 31, 2011 11:30 PM
    • Unproposed as answer by Mike Walsh FIN Friday, April 1, 2011 4:06 AM
    • Marked as answer by Mike Walsh FIN Friday, April 1, 2011 4:15 AM
    Thursday, March 31, 2011 11:30 PM
  • Thanks for your share.
    Saturday, April 23, 2011 3:03 AM