• Eesha.Singh
  • NEWBIE
  • 0 Points
  • Member since 2016


  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 4
    Questions
  • 1
    Replies
We have a custom object Price Reuqest and have complex approval processes defined for it. We want to capture the Actual Approver for each step of the approval process. I checked forums about using ProcessInstanceHistory and ProcessInstanceWorkItem but i do not understand where to start from. Any help or code or steps on how to accomplish this will be helpful.
What I need is if the payment request picklist value is "Full" and The Spin Kicker Checkbox is checked then the Spin Amount should return the value * 1.5
Else if the checkbox is not checked then it should return the value based of the Payment Request picklist value
My formula is as follows:
IF(
ISPICKVAL(Payment_Request__c,"Full"),
AND(SPIN_Kicker__c= True))
VALUE(TEXT(SPIN_Amount__c)*1.5),

IF(ISPICKVAL(Payment_Request__c,"1st Half"),
VALUE(TEXT(SPIN_Amount__c))*0.5,

IF(ISPICKVAL(Payment_Request__c,"2nd Half"),
VALUE(TEXT(SPIN_Amount__c))*0.5,

VALUE(TEXT(SPIN_Amount__c))

)))

Something is not correct, I think I have to use Case. Please advise
I am trying to solve this traihead module and I get this error.
I do not know what am I doing wrong
Save Failed
Custom Field Definition:bad value for restricted picklist field.
 
What I need is if the payment request picklist value is "Full" and The Spin Kicker Checkbox is checked then the Spin Amount should return the value * 1.5
Else if the checkbox is not checked then it should return the value based of the Payment Request picklist value
My formula is as follows:
IF(
ISPICKVAL(Payment_Request__c,"Full"),
AND(SPIN_Kicker__c= True))
VALUE(TEXT(SPIN_Amount__c)*1.5),

IF(ISPICKVAL(Payment_Request__c,"1st Half"),
VALUE(TEXT(SPIN_Amount__c))*0.5,

IF(ISPICKVAL(Payment_Request__c,"2nd Half"),
VALUE(TEXT(SPIN_Amount__c))*0.5,

VALUE(TEXT(SPIN_Amount__c))

)))

Something is not correct, I think I have to use Case. Please advise