Looking for formula help
I am trying to write a formula that will subtract to date fields only when certain conditions are met. The fields for the conditions are checkbox fields. The formula field I started below is numeric. This formula works without the conditions of the checkbox fields. If([RX Ready Date]<[Plan Set -Up All],0,(not IsNull([RX Ready Date])),ToDays(([RX Ready Date]-[Plan Set -Up All]))) I want to add to the formula to only subtract the dates when [Pharmacy], true and [Fast Track] is false (both checkbox fields). Any help to add in the conditions is much appreciated.
Help! Formula Query with multiple conditions.
My query is not returning any value for records that meet the conditions. ToNumber(ToText(GetFieldValues(GetRecords("{86.EX.'"&true&"'}" & "{15.EX.'"&[mhe_type]&"'}", [_DBID_BTS_METRICS]), 10))) I need to return the field value (fid 10) from the table [_DBID_BTS_METRICS] when field ID 86 in the queried table is true (checkbox is checked) and the value in field ID 15 is equal to the value in the field [mhe_type] in the querying table. I have tried: punctuation, format, etc numerous times using a text field to give the checkbox a yes/no value and using that field (fid 89) in the conditions in case it is the checkbox giving me the problem changing it to a SumValues query, but then it returned a value of 0.
Format Numeric Value 2 Decimal Places
Hello, I have a Formula Text that calculates and displays data based on the numbers users enter in two other numeric fields. Example: When a user enters a number in my Numerator and Denominator fields, my formula field divides those numbers and then displays the answer in the Percentage field (as shown in the screenshot below). Is there a way to format the answer to two (2) decimal places, so it's shown as something like 7.33 and not 7.3333333 ? Please let me know. See the code I used for my formula field below: var Number Numerator = [Numerator] ; var Number Denominator = [Denominator] ; ToText(($Numerator / $Denominator) & " %")Formula Rich Text: Setting a Default and Still being Editable
Hey Team! First post in the community, looking forward to seeing responses! Got a quirky question for your questing minds: I would like to set a grid table as the default value in a rich text field while still having the field be editable. We have internal customers who need a table to put in details regarding materials, like 4Cx6R, with headings on each column. Heading 1 Heading 2 Heading 3 Heading 4 Is it possible to make a table the default value and still make the rich text field editable? Thanks!Counting Instances of String across records for use in a Gauge Chart
Hi all, I want to use a gauge chart the displays the number of records that contain the letter 'R' as part of a string of in a 'Job Number' field, out of the total number of records in the table. Typically a job number field value would be in the format of 00000_00, or 00000_A0, or 00000_R00. With R denoting revised. I've tried using a query report formula, but whilst it's a valid formula attempt, it displays 0. The total number of records for the gauge var text QUERY = "{6.EX." & Contains([Job Number], "R") & "}"; Size( GetRecords($QUERY)) My logic to the above is that its querying the data table, for job number field (ID 6) to see if it contains a string with an 'R' in it, and if so count the total number of true records. Any ideas? It would be awesome if the gauge can be coloured to show the revised element in red, but the remainder of the gauge in green. But I really think that's beyond the limits of what is possible. However, if anyone has an idea how this could be accomplished, that would be absolutely appreciated!
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.Duplicate Values Between Two Tables
Hi Everyone, I will preface this with formulas are new to me. I have two tables Table 1 (Preferred Provider): This is the master table of only the preferred providers identified by Provider ID Table 2 (Member Assignments by Provider): This table is the universe of all member assignments-both preferred and non preferred. Providers are identified by Provider ID What formula (and formula field) do I use in Table 2 that will look for a Provider ID match in Table 1 that will populate the new field in Table 2 as yes or no? This app won't have user entries so I don't think I need a relationship. I just need to be able to match the preffered providers assigned in Table 2 to the master preferred provider list in Table 1. I tried something super simple which, as you likely know, didn't work. IF(Size(GetFieldValues(GetRecords("_DBID_ASC_PREFERRED_PROVIDERS.PROV_ID = _DBID_MEMBER_ASSIGNMENTS_BY_PROVIDER.PROV_ID")) 0,"Yes","No")Identifying identical values between two table
Hi Everyone, It's been a while since using QB and my brain appears to have lost QB memory! I have two tables: Preferred Providers eligible for auto-assignment All Providers that have been auto-assigned (regardless of preferred designation) I am looking for a formula that will look for a TIN match between both tables and pull into table 2 under new field "Preferred Provider" Ultimately, I need to identify the auto assigned preferred providers without scrubbing a list of thousands of TINs. Any help is greatly appreciated!
