I tried to solve the problem for hours, but I totally failed and hope you can help me now. :(
I have an app with different number fields, each has its "own" date field:
number field 1
date field 1
number field 2
date field 2
number field 12
date field 12
Now, I'd like to sum up the number fields, that have date fields, which match a certain month e.g. June.
I thought of creating additional calculation fields for each month in the same app, where I can sum up the month results for later use.
If date field 1 is in June add number field 1
if date field 2 is in June add number field 2
Thanks in advance!
Please sign in to leave a comment.