Forum Discussion
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...
Hi dskeane
Have you considered creating a calculated column that incorporates that logic?
And then you can create simple measures over the new column.
LaborBilling Data Type:Text Format:Text
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!
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.