More than 1 year has passed since last update.

切のいい値（小数）だけを認める検証ルール

Salesforce

Last updated at 2022-03-28Posted at 2021-03-08

一旦textにして右端を切り出す方法を使うといいようです。

AND(
(Number__c - ROUND( Number_1__c , 0)) <> 0 ,
CONTAINS( TEXT(Number_1__c), "."),
RIGHT( TEXT(Number_1__c), 3) <> ".25",
RIGHT( TEXT(Number_1__c), 3) <> ".50",
RIGHT( TEXT(Number_1__c), 3) <> ".75"
)

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up