Help
threehex
4 - Data Explorer
4 - Data Explorer
since ‎Apr 01, 2019
‎Nov 29, 2022

User Statistics

  • 3 Posts
  • 0 Solutions
  • 0 Kudos given
  • 0 Kudos received

User Activity

I’m averaging 3 columns, all rollups. Note that I have this formula in them, so certain cells are blank: IF(ISERROR(AVERAGE(values))=0,AVERAGE(values),BLANK()) The 4th column, where I want to average THOSE columns, has NaN if all 3 columns are blank....
Hey folks - can’t seem to find this in the forum. We have an Overview table that has records that correspond to dates - every month for each year (say 2019 and 2020). In another table, we have a Linked Record column, where one can select which Overvi...