Published on InterSystems Developer Community (https://community.intersystems.com)

Home > Calculated Fields

Question
Derrek Kegler · Mar 4, 2017

Calculated Fields

  1. How can I create a calculated field to give the previous date. For example, I need to create a pivot table that shows total payments posted for the prior day.

  2. How to create a calculated field to show average daily collections divided by the number of the days passed in a month. So, for today, it would be the average daily collections divided by 4days.

Thanks!

#InterSystems IRIS BI (DeepSee)

Source URL:https://community.intersystems.com/post/calculated-fields