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
KMNKMN 

Can Someone Help me to create a Validation.

Hi Community,
 
I have Some fields on Account Object.
Fields                       DataType
Count__c                     Number
Count1__c                   Currency
Count2__c                   Number
Final_Count__c            Formula
in the Final Count i used a Formula........ 
Count1__c / Count__c  / 1000 *  Count2__c
The Requirement is if i putt 0 (zero) in count therefore Final Count Should not be null.
Like in image shown there will be value of Count1 and Count2 If i put 1 or any number that should Count and value get printed in Final Count. Means 0 (Zero we have to ignore if we put zero in any three field.. it is possible to do Like this by any Condition check.
User-added imageThank You in Advanced
AnkaiahAnkaiah (Salesforce Developers) 
Hi KMN,

Please try with below code. 
IF(OR(ISNULL(Count1__c ), ISNULL(Count__c), ISNULL(Count2__c)), 0
,(Count1__c / Count__c  / 1000 *  Count2__c))

If this helps, please mark it as best solution.

Regards,
Ankaiah
KMNKMN
Hi Ankaiah,

If i put 0 in Count__c then Formul should work only.
Count1__c / 1000 * Count2__c
if i put 1 or any number in Count__c then formula should be work like
Count1__c / Count__c / 1000 * Count2__c

is it possible
Thank You
Sandro RamirezSandro Ramirez
I needed some assistance to gather facts and resources for my research work. I used capstone research paper (https://www.capstoneproject.net/) to help and get everything for me, so I could focus on more important work. They provided reliable services at affordable prices. I am really satisfied! Very professional, quick, reliable, well worth the money. Thanks a lot for their brilliant support. I would highly recommend their fabulous services to everyone.