If Statement

[dskeane]

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 with a project" 

Project Scope

New

Upgrade

Custom Dev

Looking to create a measure that  IF Project Scope = 'New' then take LaborTotal Column/125, IF Project Scope = 'Upgrade' then take LaborTotal Column / 100, IF Project Scope = ' Custom Dev' then take LaborTotal Column/200.

ProjectScope and LaborBilling are not calculated columns. 

Using data grid to display project name and new measure is the end result.

Any thoughts are appreciated. 

[Phil_Seamark · Accepted solution]

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]

 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]

Hi @dskeane

What is the datatype of your [LaborBilling] column?

[dskeane]

LaborBilling Data Type:Text Format:Text

[Phil_Seamark]

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.

[dskeane]

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!