Return to FileMaker.com
calculation between two sums placed on two different filtered portals
I have two date range filtered portals (on two tabs), that both have a one line portal sum field.
Is it possible to make a calculation between the two sum fields, that will respect the date range?
Not and get the values from a filtered portal.
But there are alternative methods. You can use a relationship that matches by date range.
You can use ExecuteSQL to get the same sub totals.
Retrieving data ...