function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Jess coreJess core 

Floor function not correct

Hi,

I am building the process with the following criteria.  If this is true, it would run an email alert.  However,  the email is still being recieved even if the floor expected invoice (currency field) is equal to the floor quoted amount (formula currency field).  Both fields have 2 decimal places.
  
AND(
FLOOR([Quote_Line__c].ExpectedTotalInvoice__c ) > FLOOR([Quote_Line__c].QuotedTotal__c ),
NOT(ISNULL([Quote_Line__c].ExpectedTotalInvoice__c )) ,
NOT(ISNULL([Quote_Line__c].QuotedTotal__c ))
)

 
Ajay K DubediAjay K Dubedi
Hi Jess,

I hope you are doing good and I have executed your formula in my process builder it's working fine as per the requirement.
I have created a process builder for the same formula and use the below formula as you have given and when we create a record it's working fine.
AND(
(FLOOR([Quote_Line__c].ExpectedTotalInvoice__c ) > FLOOR([Quote_Line__c].QuotedTotal__c )),
NOT(ISNULL([Quote_Line__c].ExpectedTotalInvoice__c )) ,
NOT(ISNULL([Quote_Line__c].QuotedTotal__c ))
)

I hope you find the above solution helpful. If it does, please mark as Best Answer to help others too.
Thanks,
Ajay Dubedi