LoginSignup
0
0

More than 1 year has passed since last update.

@Keiji_otsubo(Keiji Otsubo)

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

Last updated at Posted at 2021-03-08

Answersで回答する時に使う情報のまとめに戻る

一旦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"
)
0
0
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
Sign upLogin
0
0