Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

VAR formula error

Hi Community,

Sorry for what I am sure is staring me right in the face. I am getting a syntax error with this VAR statement. What am I missing?

 

VAR OpportunityRecordType_Test_3 = IF ( ( LOOKUPVALUE('Record Type'[Name],'Record Type'[Id],'Opportunity Detail'[RecordTypeId] ) = "New/Expansion", True, False )

 

Thanks,

Jim

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    Well, you have 3 left parens and only 2 right parens...
    • Anonymous's avatar
      Anonymous
      Not applicable

      Thanks Greg! Like I thought - staring me in the face. 

       

      Whne I try and accept the solution, I am getting an authentication error. Will try and fix that and give you the nod.