Assuming round is required, the following 25 results were found.
-
A very quick article on a cool snippet of code, another regular expression, I've been trying out to round up a number or at least to remove the trailing zeros. I could have added this to my Zoho Deluge - Some Useful Regular Expressions list but I felt...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
the field that is being changed: Decimal places for the Unit Price field should be less than or equal to 6 . How? The workaround for staff is to round this up manually and then save the record. But this can be an annoying overhead, especially if it can...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
titled something along the lines of truncating to 2 decimals but finance is so much more complicated. Why? Playing around with VAT / Tax, inclusive /exclusive, but in this case it is the rate that gets rounded. The numbers at the end still need to match...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
FileAppend, %v_CsvLine%, %v_RunFolder%\Log.csv } LV_ModifyCol() LV_ModifyCol(5, 0) LV_ModifyCol(6, 0) v_ForeignKeyPercent := Round((v_FKCountTotal / v_FileCount) * 100, 2) v_ZohoKeyPercent := Round((v_PKCountTotal / v_FileCount) * 100, 2)...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
; converts Size (in bytes) to byte(s)/KB/MB/GB/TB (uses best option) ; decimalPlaces is the number of decimal places to round ; -------------------------------------------------------------------------------------- autoByteFormat(size, decimalPlaces =...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
*/ #my-footer{ text-align:center; font-size:7pt; text-transform: uppercase; } #my-container hr{ border: 0; height: 1px; background-image: linear-gradient(to right, rgba(0, 0, 0, 0), rgba(0, 0, 0, 0.75), rgba(0, 0, 0, 0)); } My Company Ltd Test Street,...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
day = 26640 seconds and 1440 minutes = 24 hours. -- 0.07 person days = 30 minutes or 0.14 person days = 1 hour. 0.04166667 =(ROUND(B5/0.07, 0)*30)/1440 -- now format to [h]:mm:ss -- yields 1:00:00 0.04166667 =(ROUND(B5/0.07, 0)*0.5)/24 -- now format to...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
In this case, I want to display the current month with today highlighted. As I was trying to get my head round writing this in a program using the qHTM.dll (to include HTML in an autohotkey GUI), the calendar will be in a HTML-autohotkey mixed code....
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
speed and reliability. SetWorkingDir %A_ScriptDir% ; Ensures a consistent starting directory. SetFormat, float, 0.2 ; Round any floats to two decimals ;...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
// yields Posh and David Beckham UK/US Decimal Separator and Commas: v_MyString = 1234.567; v_FormattedString = (v_MyString.round(2)).toString().replaceAll(("(?Link"; v_FormattedString = v_MyString.replaceAll("^.*href\s*=\s*\"([^\"]*)\".*$","$1"); //...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
= 1; } v_AcosDist = acos(v_Dist); v_CalcDist = v_AcosDist * 180 / v_MathPi; v_Miles = v_CalcDist * 60 * 1.1515; } return round(v_Miles,2) + " miles"; } For kilometres, simply multiply the miles value by 1.609344 if (unit=="K") { dist = dist * 1.609344 }...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
Here's the standard code you'd expect if your Fiscal year starts in January (Divide by 3 and round up): for each v_Month in l_Months { v_Quarter = (v_Month.toLong() / 3).ceil(); info "Month: " + l_MonthNames.get(v_Month-1) + " :: Quarter: " + v_Quarter;...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
order to invoice" button, I needed a way to programmatically link the sales order to the invoice. Why? The documentation around the API does not detail how to do this. I also couldn't find any search result via Google or DuckDuckGo (can't say for Bing,...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
type : POST parameters: l_ShopifyUploadImages.toString() headers: m_Header ]; Correction / Additional version 2.0 Playing around with this for a client, I found an even better solution! When creating or updating a product, you can instead of giving it...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
and what's important to note here is that each picklist/dropdown option includes some HTML, specifically a SPAN tag surrounding the date number (eg. "Wednesday9March"), which yields the following: Then I get rid of the label with the following CSS:...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
"); // adding an apostrophe/single-quote to ID values so MS Excel doesn't round them up v_ProductIDStr = "\"'" + v_ProductID + "\""; v_VariantIDStr = "\"'" + v_VariantID + "\""; v_InventoryIDStr = "\"'" + v_InventoryID + "\""; // // generate CSV row for...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
deposit amount (half of grand total) but on the final balance invoice, we are deducting the deposit v_DepositAmount = Math.round((v_QuoteGrandTotal / 2) * 100) / 100; // conditions based on the invoice type if (v_InvoiceType == "Final Balance") {...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
- $w_value AND s.StaffUserID='STRING_TO_REPLACE_PER_ITERATION' ) AS 'Total', ( SELECT ROUND((SUM(TIME_TO_SEC(s.EstimateTimeFinish)-TIME_TO_SEC(s.DateTimeCreated))/26640),2) AS SecondsElapsed FROM StaffActivities s WHERE...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
? 's' : ''; // only add to array if not empty/zero if($v_Str!='') $a_UnitPairs[] = $v_Str; } // take first item of array (round up to largest unit) $v_ReturnStr = $a_UnitPairs[0].' ago'; // return return $v_ReturnStr; } Usage $v_Str =...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
Pancakeshttps://www.joellipman.com/component/content/article/pancakes.html?catid=96&Itemid=165
into it. Then begin whisking the eggs - any sort of whisk or even a fork will do - incorporating any bits of flour from around the edge of the bowl as you do so. Next gradually add small quantities of the milk and water mixture, still whisking (don't...
- Type: Article
- Author: Joel Lipman
- Category: Hobbies
- Language: *