Forum Discussion

dskeane's avatar
dskeane
Helper I
8 years ago
Solved

If Statement

Looking to figure out a solution with multiple If statements. Scenario below.    Example, I have a column called ProjectScope / LaborBilling "Labor billing reflects the total revenue associated wit...
Need Help
Tips and Tricks
  • Phil_Seamark's avatar
    Phil_Seamark
    8 years ago

    Hi dskeane

     

    Have you considered creating a calculated column that incorporates that logic?

     

    And then you can create simple measures over the new column.

dskeane's avatar
dskeane
Helper I
8 years ago

 This will get me on the right track, however I am running into an issue with the error in the screen shot. T&M is coming from another colum not related to my formula?

 

Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
8 years ago

Hi dskeane

 

What is the datatype of your [LaborBilling] column?

  • dskeane's avatar
    dskeane
    Helper I
    8 years ago

    LaborBilling Data Type:Text Format:Text

    • dskeane's avatar
      dskeane
      Helper I
      8 years ago

      Nevermind, oversite on my end. I should have been using another colum called calculatedlaborttl this has a decimal data type. 

       

      I am smooth sailing from this point on, thanks for the suggestion! 

    • Phil_Seamark's avatar
      Phil_Seamark
      Microsoft Employee
      8 years ago

      I think this is the problem.  You have text in that column and you are trying to use a mathmatic operator with a text value.

       

      You can extend your IF statement to only look for numeric values, or filter out the text from this column and convert the column to numeric.