Formula Query with options
Hi, Is it possible to sort the results from a formula query. I have a formula query to get list of dates from a table. I would like to get the latest of the returned dates. Is it possible to use options=sortorder-D in the formula query? var text Query = "{65.EX.'" & [PBG Number] & "'}"; var number NUM = Size(GetRecords($Query, [_DBID_ACTION_ITEMS])); If([Active_Ind] = true and $NUM > 0, ToText(GetFieldValues(GetRecords($QUERY,[_DBID_ACTION_ITEMS]),2)) )22Views1like1CommentFormula 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)38Views1like1Comment