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.
Thanks, I’ll check that out. The general rule is if you are referring to the contents of the field or variable, you don’t quote it, but if you are referring to the entity itself, you usually have to quote it (though there are exceptions, like the let statement, and in some places like lookup( functions it can be either way).