In a formula, I want to return the sum of the field Cost where the field Month value matches Month in the current record. Seems like a simple idea but I have not found the formula. I eventually tried this formula:
This formula crashes Panorama every time in formula workshop. This technique (using ignore and cache with the aggregate function) is suggested on the Help page for the aggregate formula.
Any suggestions would be appreciated.