cancel
Showing results for 
Search instead for 
Did you mean: 

need to more standard Functions for SFM Formula. FIND TEXT VALUE LEFT ROUND

hagiwararyu
Grill Chef
Grill Chef

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.

ex.1

 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 * 10 = 42900 JP Yen



But Servicemax Standard calculate are below.

ex.1 SVMX's standard

 Listprice 5050.000 JPYen
 15% Discount 4292.500 JPYen
 Qty: 1

   Billable Price  :  4290.500 * 1 = 4290.500 JP Yen //not correct: 0.500Yen is not exist in Japan.

ex.2 SVMX's Standard
 Listprice 5050.000 JPYen
 15% Discount 4292.500 JPYen
 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()


regards,

Hagiwara

Tamaki_Sato
Employee
Employee

User Reply need to more standard Functions for SFM Formula. FIND TEXT VALUE LEFT ROUND Tamaki_Sato

0 Likes
Reply