• dolphin
  • NEWBIE
  • 0 Points
  • Member since 2008

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 0
    Replies
Hello Everybody,
 
I wonder if someone ever seen this situation. I am relatively new to SF, hope somebody can help.
 
I have different selling services (26) and the fees are changing according to the billing cycle (yearly or monthly) and their types.
 
Therefore, I want to create a rule that is going to relate: the ispickval (Service) and the BC (Y or M)
 
I tried with the functions IF and AND,
 
IF(
AND(ISPICKVAL(A),ISPICKVAL(Y),Fees1),
AND(ISPICKVAL (A),ISPICKVAL(M),Fees2),
AND(ISPICKVAL(B),ISPICKVAL(y), Fees3),
AND...,
null)
 
I have a report that something is missing, but I can not find what and how I should do that.
 
If someone can help!
 
Thanks in advance. <Dolphin