No announcement yet.

How to create Calculated value formula

  • Filter
  • Time
  • Show
Clear All
new posts

    How to create Calculated value formula

    Hello all,

    How to create calculated value in Schedules by using Count parameter? I knew that count cannot be used as a fields but any other alternate method is available to proceed further. Please help me in this case.

    Thanks in advance

    You can’t.

    You can work around it by setting a new calculated value to 1, totaling that column, then another calculated value that shows to percentage of the “1” parameter relative to the total/sub-total, and finally one more calculated value that takes the invert of the percentage (1/%) which will give you the total/subtotal in each row.

    That was from memory so I might have missed something... if I remember I’ll share an example later today.

    Sent from my iPhone using Tapatalk
    Greg McDowell Jr


      There are several threads about a solution to this.

      (Also known as the "Total Mayhem" solution, so you can search for that too.)
      "One must imagine Sisyphus happy." Albert Camus - "The innovator has for enemies all those who have done well under the old conditions, and lukewarm defenders in those who may ​do well under the new." Nicolo Machiavelli -"Things that are too complex are not useful, Things that are useful are simple." Mikhail Kalashnikov


      Related Topics