This discussion is archived
0 Replies Latest reply: Oct 9, 2012 2:13 PM by 967264 RSS

Function IIF do not work on Opportunity Product Revenue

967264 Newbie
Currently Being Moderated
Hi all,

We've created an item in the Product Window. Product's name is CPA.

In addition, in form "Opportunity Product Revenue" , we created a function in "Purchase Price" field. Days ago, that function worked succesfully, but today it's not working.

The function is: IIf([<ProductName>]= 'CPA', '3600', '1100'). We choose "CPA" in product field, and according to function, in "purchase price" field must refresh with value '3600'. But function returns '1100'.

Can you help me?


  • Correct Answers - 10 points
  • Helpful Answers - 5 points