3 Replies Latest reply on Mar 23, 2016 7:18 AM by Mark Fraser

    How do I get past "Expected Type Float, Found String" error

    ailsa.zheng

      This is my calculation:

       

       

      I have one data source with my company's sales data and another data source with each salesperson's sales targets. Let's say there are 5 days left in the quarter, and they need $20,000 more to hit their goal. My calculation would come up with "4,000" which is currently does. On the other hand, if the salesperson has already reached their target, I don't want a negative number to show up, I just want it to say "TARGET REACHED" but right now there's an error message. How can I get around that?

       

      I tried making an Ifnull, but if I do Ifnull([Revenue to hit Target],"Target Reached") I will get the exact same issue.

       

      Thanks in advance!