I have Validation rule on opportunity (when subscription product > 1 And " XYZ"  ISBLANK AND Problatity > 50)
show error message.
At current situation there is opportunity which satisfies all the condition, when I try to add product it throws error message on opportuniy multilineitem page.
I don't want opportunity validation rule to fire when I add or delete opportunity line item.
Only when someone edits opportunity.


AND
(
AND
(OR( Subscription__c > 0, Services__c > 0),AND(Probability >=0.5, Probability <> 1), ISPICKVAL(Pre_Buy_or_NRE__c,'NO'), ISBLANK(Text(Mission_Critical__c))

),

AND
(
$Profile.Name <> 'API Only User',$Profile.Name <> 'Custom System Administrator',$Profile.Name <> 'System Administrator',$Profile.Name <> 'Configuration System Administrator'
)

)

How do I acheive this?

 

Hi I have written validation rule on opportunity.
I want this validation rule to trigger only for certain profile like "Regular User". Its not happening when I as a(Admin) edit opportunity and condition satisfy it gives me errror message too . Below is validation rule.

AND
(
AND
(ISCHANGED(StageName),OR( Subscription__c > 0, Services__c > 0),AND(Probability >=0.5, Probability <> 1), ISPICKVAL(Pre_Buy_or_NRE__c,'NO'), ISBLANK(Text(Mission_Critical__c))

),

OR
(
$Profile.Name <> "API Only User",$Profile.Name <> "Custom System Administrator",$Profile.Name <> "System Administrator",$Profile.Name <> "Configuration System Administrator"
)

)


Thanks,
Archana

Hi

 

I am trying to create formula to calculate discount  ((ListPrice - UnitPrice ) / ListPrice) * 100 on quote line item.

I can see ListPrice read only field is there on quote line item still I am getting error ListPrice field does not exist.

 

Or

Is there any waty I can bring discount amount from opportunity line item.

 

Thanks,

I have Validation rule on opportunity (when subscription product > 1 And " XYZ"  ISBLANK AND Problatity > 50)
show error message.
At current situation there is opportunity which satisfies all the condition, when I try to add product it throws error message on opportuniy multilineitem page.
I don't want opportunity validation rule to fire when I add or delete opportunity line item.
Only when someone edits opportunity.


AND
(
AND
(OR( Subscription__c > 0, Services__c > 0),AND(Probability >=0.5, Probability <> 1), ISPICKVAL(Pre_Buy_or_NRE__c,'NO'), ISBLANK(Text(Mission_Critical__c))

),

AND
(
$Profile.Name <> 'API Only User',$Profile.Name <> 'Custom System Administrator',$Profile.Name <> 'System Administrator',$Profile.Name <> 'Configuration System Administrator'
)

)

How do I acheive this?

 

Hi I have written validation rule on opportunity.
I want this validation rule to trigger only for certain profile like "Regular User". Its not happening when I as a(Admin) edit opportunity and condition satisfy it gives me errror message too . Below is validation rule.

AND
(
AND
(ISCHANGED(StageName),OR( Subscription__c > 0, Services__c > 0),AND(Probability >=0.5, Probability <> 1), ISPICKVAL(Pre_Buy_or_NRE__c,'NO'), ISBLANK(Text(Mission_Critical__c))

),

OR
(
$Profile.Name <> "API Only User",$Profile.Name <> "Custom System Administrator",$Profile.Name <> "System Administrator",$Profile.Name <> "Configuration System Administrator"
)

)


Thanks,
Archana

Hi

 

I am trying to create formula to calculate discount  ((ListPrice - UnitPrice ) / ListPrice) * 100 on quote line item.

I can see ListPrice read only field is there on quote line item still I am getting error ListPrice field does not exist.

 

Or

Is there any waty I can bring discount amount from opportunity line item.

 

Thanks,

Problems:

1)If DOB is Feb 29 Leap year.How to find next birthday for that particular date?

No Need Validation rule for this code.

End-of-century years 1700, 1800,1900,2100 these years are not leap year in these problems are resolved.........

To find the next Birthday formula

How to create......

step-1: create the custom field for Date of Birth----It's type-Date

step-2: create the formula field for Birthday ---It's type-Date

code:

if(
MONTH(ramki__DOB__c) = 2 &&
DAY(ramki__DOB__c) = 29 ,
DATE(IF(Year(today())<=Year(ramki__DOB__c),
Year(ramki__DOB__c),
IF(
OR(MOD(Year(today())+4-MOD(Year(today()),4),400)=0,
AND(MOD(Year( today())+ 4-MOD(Year(today()),4),4)=0,
MOD(Year(today())+ 4-MOD(Year( today()),4),100)<>0)),
Year(today())+ 4-MOD(Year( today()),4),
Year(today())+ 8-MOD(Year( today()),4))
),
MONTH(ramki__DOB__c),DAY(ramki__DOB__c)),
if(Year( today()) <= Year( ramki__DOB__c)  ,
DATE(Year(ramki__DOB__c),MONTH(ramki__DOB__c),DAY(ramki__DOB__c)) ,
IF (DATE (YEAR(TODAY()),MONTH(ramki__DOB__c),DAY(ramki__DOB__c)) > TODAY(),
         DATE (YEAR(TODAY()),MONTH(ramki__DOB__c),DAY(ramki__DOB__c)),
         DATE (YEAR(TODAY())+1,MONTH(ramki__DOB__c),DAY(ramki__DOB__c))
       )))

it's correctly worked for leap year dates.......
this is code for find the next Birthday friends......


Easily Calculate Age:

create formula field -------(Number)

Age=YEAR( ramki__BirthDay__c) - YEAR(ramki__DOB__c)
----
softramki@gmail.com
+919944112175