5 Replies Latest reply on Jul 4, 2018 7:44 PM by mursid rahman

    String Calculation

    mursid rahman

      Hello, data heroes!

       

      I need your help. For this work, I want to do some string calculation. A very simple one but I still manage to mess it up. Here's the use case.

       

      I want to show the number of sales that are under $1000 and over $1000 by customer. The calculation that I came up with is like below;

       

      IF ATTR([Status]) == "Over"

      THEN

      COUNT([Status])

      END

       

      Here's the problem. After dragging the calculated filed onto the Label/Text, it turned out blank. I've also provided a packaged workbook.

       

      Help me! and Thank you.