• Katy Watson.Admin
  • NEWBIE
  • 0 Points
  • Member since 2023

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

I'm trying to create a report using the IF Function but am receiving the "Warning Incorrect parameter type for function 'IF()'. Expected Number, received Text" error message. 

The formula I'm trying to make work is: 
IF(Field 1 > 0.00, Field 2 - Field 1, "") 

All Fields in the formula are set as Currency fields. 

Thanks
Katy