Forum Discussion
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 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.
Hi dskeane
Have you considered creating a calculated column that incorporates that logic?
And then you can create simple measures over the new column.
6 Replies
Hi dskeane
Have you considered creating a calculated column that incorporates that logic?
And then you can create simple measures over the new column.
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?
