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)) )
IF AND Formula
I am trying to write a report formula that is triggered off a checkbox and two different dates that I would typically write an IF AND formula. Anyone know how to make this work? It is giving me an 'expecting ,' error. The Cybersecurity field is a checkbox. The Engagement Begins is a date field. The Cybersecurity Discovery Engagement Ends is a date field. The logic should read if the Cybersecurity checkbox is checked AND the Engagement Begins field is blank, then the field should read "Upcoming", but if the Cybersecurity checkbox is checked AND the Engagement Begins field is not blank, and the Cybersecurity Discovery Engagement Ends field is blank, then the field should read "Assigned", otherwise show nothing.
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)
