Forum Discussion

dskeane's avatar
dskeane
Icon for Helper I rankHelper 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.

Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
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
Icon for Helper I rankHelper 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
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi dskeane

     

    What is the datatype of your [LaborBilling] column?

    • dskeane's avatar
      dskeane
      Icon for Helper I rankHelper I
      8 years ago

      LaborBilling Data Type:Text Format:Text

      • dskeane's avatar
        dskeane
        Icon for Helper I rankHelper 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!