• Antti Kaatonen
  • NEWBIE
  • 0 Points
  • Member since 2023

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 2
    Replies

Hello wizards, what's wrong with this code? First it says it doesn't recognize >= and <= and when you add quotations, it starts with: syntax error missing ')'. Trying to do 12 months running sales. Please help.
 
IF(
  AND(Opportunity.CloseDate">=" (TODAY() - 365),
    Opportunity.CloseDate "<=" TODAY()
  ),
  Opportunity.ExpectedRevenue,
  0
)

Hello wizards, what's wrong with this code? First it says it doesn't recognize >= and <= and when you add quotations, it starts with: syntax error missing ')'. Trying to do 12 months running sales. Please help.
 
IF(
  AND(Opportunity.CloseDate">=" (TODAY() - 365),
    Opportunity.CloseDate "<=" TODAY()
  ),
  Opportunity.ExpectedRevenue,
  0
)
IF(  ROI_No_of_Months__c  < 13,
IMAGE("//c.na139.content.force.com/servlet/servlet.FileDownload?file=0154W00000BiFeo", "green", 30, 30)
IF( ROI_No_of_Months__c  > 24,
IMAGE("//c.na139.content.force.com/servlet/servlet.FileDownload?file=0154W00000BiFee", "yellow", 30, 30),
IMAGE("//c.na139.content.force.com/servlet/servlet.FileDownload?file=0154W00000BiFej", "red", 30, 30),
))

Any help would be appreciated.  Thanks!