Jump to content

pmassin

Newbies
  • Content Count

    2
  • Joined

  • Last visited

Community Reputation

0 Neutral

About pmassin

  • Rank
    newbie

FileMaker Experience

  • Skill Level
    Intermediate
  • FM Application
    17

Platform Environment

  • OS Platform
    X-Platform
  • OS Version
    Mojave
  1. Hi all, I have 2 repeating fields, Turnover last year & turnover this year, each with 12 repetitions. I would like to compare the year to date turnover with same period last year. EG If the current year has 3 months of turnover, the 3 first months have to be compared with the 3 first months of last year, and so on. So using the COUNT function, I can determine that 3 months of this year have Turnover. How can I dynamically make the sum of only the first 3 months of last year although all 12 repetitions cells have a value? I was thinking of using the let function to avoid a lenghty calculation, but I don't grasp how to make the recursion... Thanks for helping me out!
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.