ANGELARIVERA
4 months agoQrew Member
Formula with Exclusion
I'm trying to figure out how to work an exclusion in my formula. I am trying to calculate the sum of all records cost for a certain director but only for trips where the member actually traveled. If the member did not travel, a checkbox will be checked to exclude those records from the total cost.
This formula almost works but once I check a "Did not travel" box, it excludes all costs when I just want it to exclude the records that the "Did not travel" box were checked and calculate the sum of all others.
If((([L3]="Caty")and([Did not Travel]=null)),(SumValues(GetRecords("{33.GT.01-01-2024 and LT.12-31-2024}"),55)),0)