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.
Count instances of value in table prior to date
Hi everyone, I'm trying to find a way to create a field that counts the # of times an email address exists within a table based on a date field within that record. Example: Record is created with an email address and a date of interaction. Goal - return the # of times that email address already exists in other records on or before the date of that interaction. My formula query currently is: Size(GetRecords("{145.OBF.'" & [Date of Interaction] & "'}")) Which DOES work, but it's counting huge numbers, and I don't understand why. The results are in the thousands, for an email address that if I search for it, only exists 21 times. I *think* it's because my field 145 is also a formula query which reads - Trim(If([NEW Contact Email Address]="",[Contacts Table Field - Email Address],[NEW Contact Email Address])) I'm wondering if it's not counting the results in the field, but query; however, when I switched the field to the field 'NEW Contact Email Address] I returned tens of thousands of records rather than the very few times a staff member manually entered it as a 'NEW' contact rather than looking up the email from our contacts table. Ideas? and thank you!
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) & " %")Expanded URL to Formula Query
Hello, I am hoping someone much smarter than I can help solve this puzzle. I have a report on an activities table. I want to search the same parameters that the report has within a size(GetRecords()) formula query in order to showcase how many records the user can expect to generate. The first thing I did was to go to the report, unswitch the 'new style', choose 'more', and then select "show expanded url for this report". Which gives me this (made minor change to allow the formula query to save): Size(GetRecords((("{'33'.IR.'this+wk'}OR{'33'.BF.'today'})AND{'76'.XEX.'No+Street+Address'}AND{'61'.XEX.'No+Employer+Name'}AND{'68'.XEX.'0'}AND{'19'.EX.''}AND{'82'.EX.'Send+Letter'}AND{'60'.XEX.'ABC'}AND{'69'.XEX.'Paid'}AND{'69'.XEX.'Promise+to+Pay'}AND{'69'.XEX.'Escalated'}AND{'17'.EX.'Delinquent+in+30+days'}")), [_DBID_ACTIVITIES])) The above expanded url equals the below (report parameters) How can I modify this expanded url and turn it into a workable formula query? Any and all tips/ tricks are welcomed. Thank you!
