Sum of Calculated Field

  • Resolved craigmcgoldrick

    (@craigmcgoldrick)


    2 years, 7 months ago

    I have a pivot table and have created a calculated field with an IF formula to return the higher value of other calculated fields. However, the subsection of the items isnt summing the total of the items within it, I have done some research and believe it may be to do with the IF formula, any suggestions/answers?

Viewing 1 replies (of 1 total)
  • Plugin Author codepeople

    (@codepeople)

    Hello @craigmcgoldrick

    I’m sorry. Your description is too general. So, I’ll try to describe a hypothetical example that could help you.

    Assuming you have multiple calculated fields, fieldname1, fieldname2, fieldname3, and you want to get the higher value. The equation would be simply:

    MAX(fieldname1, fieldname2, fieldname3)

    And that’s all. You don’t need to use IF operations.

    Best regards.

Viewing 1 replies (of 1 total)
  • The topic ‘Sum of Calculated Field’ is closed to new replies.