Summarize a value in the same table
I'm building a new Table [Daily Time Cards], now trying to calculate for overtime. I built formula fields for week and year number, with the idea that I would query the same table for [Related Team Member] those number fields and only render total hours logged for the week, not on the same Record ID (or blank, since could be the case initially). Example: A user logging time submitted 38 hours previously this week in prior saved time cards. On Friday they have 4 hours to log. The highlighted field should summarize to 38 The formula for the new timecard should calculate 2 hours at regular time, and 2 hours OT I attempted to make this field work with a formula Query, then tried doing a self to self relationship. I think the FQ is the way to go, but I get an error "Expecting Records list but found text list" on GetFieldValues. SumValues( GetFieldValues( GetRecords( "{Related Team Member.EX.'" & [Related Team Member] & "'}" & " AND {Week Of Year.EX." & [Week Of Year] & "}" & " AND {Record ID#.EX.NOT." & [Record ID#] & "}", [_DBID_DAILY_TIME_CARDS] ), 36 ) ) Recommendations are appreciated.
Formula Help
Hello, I need help combining text fields into a formula(s). Here are my formulas: [Finance Disposition]=""&[(Text) PipeLine Value Requested]="<$500,000"),"YELLOW") I'm getting the operator "=" can't be applied on types bool, text error message [Current Status]="Submitted",[Finance Disposition]="",[(Text) PipeLine Value Requested]="<$500,000","Red") I'm getting expecting text, but found bool error message
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)) )
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)
