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
