need to more standard Functions for SFM Formula. FIND TEXT VALUE LEFT ROUND
We want to calculate for Estimate on FSA App (iPad/Android) FSA's advantage point able to use "OFFLINE". And Estimate's Calculation needs SFM Formula on FSA APP. We want to add standard Functions of SFM Formula.
Japanese currency has no decimal point. Must be rounded down or rounded up or other way. This time, Customer was requested to truncate less than 10 yen.
Our Customer needs calculates on ipad/Android, The details want to calculate are below.
Listprice 5050.000 JPYen 15% Discount 4292.500 JPYen truncate less than 10 JPYen. 4292.500 --> 4290 Qty: 1
Billable Price : 4290 * 1 =4290 JP Yen ex.2
Listprice 5050.000 JPYen 15% Discount 4292.500 JPYen truncate less than 10 JPYen. 4292.500 --> 4290 Qty: 10
Billable Price : 4290.500 * 10 = 42905.000 //not correct : It is 5 yen higher than the real price.
Salesforce Custom field can calculate with Salesfoce's Functions about Web Online & Browser, But Salesforce's function can't use in "Ofline iPad/Android".
We need to force 0 yen for less than 10 yen, and we need to process the decimal point as text in the middle or manipulate the decimal point movement. It's not just "Round()". We need some functions. Also, the customer wants to complete only the standard SFM Formula settings rather than additional custom development with "Custom Code Snippet". If we write the source code, it may not be possible/difficult for other administrators to maintain it.
Therefore, I would like to request Service Max to develop additional functions below. ・FIND() ・TEXT() ・VALUE() ・LEFT() ・ROUND()