Continued from   Am trying to calculate remaining response time for the case.   Based on the priority of the case we are setting the remaining time to respond the case(in hours and mins).  Please see .   Important thing is, we need to show the remaining time dynamically. That is, when the page is refreshed after 10 min, it should change the remaining time dynamically. So went for the formula field to calculate. Here is my formula,  IF( caseOwnerChanged__c ,  IF(FLOOR((((CreatedDate + ( ResponseTime__c /1440 )) - caseOwnerChangedOn__c ) * 24 * 60) / 60) = 0, LEFT( TEXT(MOD((((CreatedDate + ( ResponseTime__c /1440 )) - caseOwnerChangedOn__c ) * 24 * 60) ,60)),2 )  &amp;' min', (TEXT(FLOOR((((CreatedDate + ( ResponseTime__c /1440 )) - caseOwnerChangedOn__c ) * 24 * 60) / 60))  &amp;' hr'&amp;  LEFT( TEXT(ABS(MOD((((CreatedDate + ( ResponseTime__c /1440 )) - caseOwnerChangedOn__c ) * 24 * 60) ,60))),2 )  &amp;' min') ),   IF(FLOOR((((CreatedDate + ( ResponseTime__c /1440 )) - NOW() ) * 24 * 60) / 60) = 0, LEFT( TEXT(MOD((((CreatedDate + ( ResponseTime__c /1440 )) - NOW() ) * 24 * 60) ,60)),2 )  &amp;' min', (TEXT(FLOOR((((CreatedDate + ( ResponseTime__c /1440 )) - NOW() ) * 24 * 60) / 60))  &amp;' hr '&amp;  LEFT( TEXT(ABS(MOD((((CreatedDate + ( ResponseTime__c /1440 )) - NOW() ) * 24 * 60) ,60))),2 )  &amp;' min')  ) )      caseOwnerChanged__c - Checkbox field, which returns true if owner   changed. When the case owner changes, response time should stop    wherever it is.          ResponseTime__c - formula field which returns 30 for P1, 120 for P2,    480 for   P3...          caseOwnerChangedOn__c - Returns datetime when owner changed   So, am trying to save this formula but am getting      Error: Compiled formula is too big to execute (9,018 characters).   Maximum size is 5,000 characters   I tried putting the formula's   (((CreatedDate + ( ResponseTime__c /1440 )) - caseOwnerChangedOn__c ) * 24 * 60) TEXT(MOD((((CreatedDate + ( ResponseTime__c /1440 )) - caseOwnerChangedOn__c ) * 24 * 60)   in seperate formula fields and referenced in the current main formula but it is reducing only less number of characters.   So, Any other way to simplify this formula?.
Each  has a compiled cost that contributes towards the  compiled character formula limit.  What are the current compiled costs associated with each formula function?
How do that charge gets transferred while rubbing? What can cause a question to be bumped? What can cause a question to be "bumped" to the first page in the Active tab of a Stack Exchange site? (Changing the "Last Active" date.)  . How to know when to change a chain? A bike shop employee used a tool he said would check the wear on the chain, and said that it should be changed.   He said it took a measurement that meant the chain had expanded, but it is still hard for me understand why I should change the chain.   He said that the reason was that the expanded chain links will cause the chain rings to wear down.   That is one argument and I have no experience with it, to know if it is true.   But are there more reasons? How do I know when the chain should be changed?   My first thought is to use it until it breaks, but it probably is not the wisest option. Does C1 code coverage analysis exist for Ruby? I'm currently using  to get C0 code coverage analysis for a rails project that I'm working on.  However, those results are practically meaningless- I have 100% coverage according to rcov (as it only covers C0 analysis) and I've barely written half the test cases for the functionality that exists thus far.  I'm used to the useful results from the code coverage in Visual Studio 2008 Team, which has C1 coverage.  Are there any tools that provide similar coverage for ruby? In popular science books and articles, I keep running into the claim that the total energy of the Universe is zero, "because the positive energy of matter is cancelled out by the negative energy of the gravitational field".  But I can't find anything concrete to substantiate this claim. As a first check, I did a calculation to compute the gravitational potential energy of a sphere of uniform density of radius $R$ using Newton's Laws and threw in $E=mc^2$ for energy of the sphere, and it was by no means obvious that the answer is zero!  So, my questions:   What is the basis for the claim &ndash; does one require General Relativity, or can one get it from Newtonian gravity? What conditions do you require in the model, in order for this to work? Could someone please refer me to a good paper about this? This has been nagging me for a while and then I saw  asking what the difference is between variables and parameters. In the context of mathematics, what is the difference between  variables constants parameters arguments  I get 1. and 2. confused because, for example the general form of the quadratic function is often expressed $f(x)=ax^2+bx+c, a \neq 0$ and $x$ is the variable so what does that make a,b and c? I assume since math is so rigorous with precise definitions, these have one, but it is also a valid answer that as words they do not have a single precise definition. Associativity of symmetric difference of sets Why use a z test rather than a t test with proportional data? My stance is that these websites are a great boon to the research community and they were certainly extremely helpful for my research. I think they should be applauded rather than persecuted, and while they may be illegal now, I think a way to make them legal should be found (in the same way I can download articles legally through my university's subscription to all the major publishers and journals).  Can I thank them in the acknowledgements section of my thesis? What happens when a creature enchanted with Soul Link would deal lethal damage to a player? Player A has 3 life left. Player B attacks with a  that has been enchanted by Player A's . Does player B win, or does nothing happen?  On the one hand, "whenever" makes it sound like the trigger (dealing damage) and the effect (healing damage) happen simultaneously.  On the other hand, combat damage doesn't go on the stack, while most other things do. So, possibly the combat damage is dealt, state-based actions are checked, and now it's too late for the Soul Link effect to heal player A.  If anyone knows which way is correct, my thanks! Does the Black Panther suit give extra speed? So in Civil War, the Black Panther suit seems to give the suit holder some extra speed, because the guy was running as fast as Bucky and Captain America.  So does it give extra speed? If so, how does that work? I am new to blender (yes, laugh at the obligatory doughnut) and I when I set up the camera (I use NUM 0 to access the camera and move it into position with &quot;Lock camera to view&quot;) in the viewport it shows as the first attached image, but when I render it the image is further back as shown in the second image. Is this normal behavior or am I missing something? Does it give higher quality to shoot in low-res mode in-camera, or to downsize high-res photos later? Suppose you want to store your photos at some lower resolution, let's say about ~1 MB large.  You own a camera able to make photos at 5 MPix and more.  And, you want to have the maximum quality at the smaller size.  Would it be better to make a photo at highest resolution and then resize it with PC software (with a good filter of course), or to directly set the camera to make photos at 2 MPix only? Get the last item in an array How to force a node group input field to display a slider? I have created a couple of node groups with some "group-inputs-sliders" (The one called "Roughness" in the bottom picture). I would like it to have the blue-bar slider like the blender native ones. Thanks (: How to do the port forwarding from one ip to another ip in same network? I would like do some NAT in iptables. So that, all the packets coming to 192.168.12.87 and port 80 will be forwarded to 192.168.12.77 port 80.  How to do this with iptables?  Or   Any other ways to achieve the same? I am using Selenium 2/WebDriver for automation. I have a table and am trying to select a row in it. When the test runs, I can see the row become highlighted as if it is clicked, but then immediately I get the "org.openqa.selenium.StaleElementReferenceException: Element is no longer attached to the DOM" error and the test fails.  The code is the following:  @Test public void rowSelection() throws Exception {     SeleniumHelper helper = new SeleniumHelper();     action = new SeleniumActionHelper(driver);      helper.login();      String testUrl = navigateToUrl("option/listOptions.xhtml");     driver.get(testUrl);      WebElement table = findElementById("tableSection:dataTableWrapped_data");     List&lt;WebElement&gt; allRows = table.findElements(By.tagName("tr"));     for (WebElement row : allRows)         {             List&lt;WebElement&gt; cells = row.findElements(By.tagName("td"));             for (WebElement cell : cells)             {                 WebElement listName = cell.findElement(By.xpath("./* [text()='body_build']"));                 listName.click();             }         } }   I have put a Thread.sleep(2000) in front and after the listName.click() action, but neither has helped. Any help would be greatly appreciated. Probability that the bag contains all balls white given that two balls are white A bag contains $4$ balls .Two balls are drawn at random and are found to be white.  What is the probability that all the four balls in the bag are white?.  The options are $\large\frac{1}{5}\space ;\frac{2}{5} ;\frac{3}{5} ;\frac{4}{5}$  My work: It's given that two balls are white.So the rest of the balls could be    all white One of them white none of them white   So among the three above possibilities only one satisfies our conditions so the probability is $\frac{1}{3}$.But it not even the options given. What's wrong with my work? SQL query to convert columns into rows How do you set, clear, and toggle a single bit?