Hi there. I am working with a Rollup up field linking between a Series table and ID table. The ID table has a field called Episodes. What I am trying to work out is how do I display the number of episodes linked from the linked ID table and the count...

Hi there, I have a table with a Name field and in that field (in different variations and location in the text string) is a series number as either 001 or 1. In a Series No. field I am including a formula that extracts just the series number. I am tr...

Hi there, So I have a Table were I am tracking Costs in one field and in another field I have Financial Years. Financial Year 19/20 Costs $100 Financial Year 20/21 Costs $200 What I would like to be able to do create another field where I calculate t...

Hi there, I would love to get some guidance on how to do something like a conditional roll up within one table. If you see the table example below you can see that I have contractual start and end dates that I want to use as a guide for calculating T...

I have two fields (both are rollups - sum’s) that results in numbers: Projection Views Actual Views I have set up another field with this formula: SUM({Projected Views}-{Actual Channel}) But the formula returns a NaN. Can someone help me understand w...