Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

If Measure

i have a table with expected Billable Hour and I'm trying to figure out how many hours each person can contribute. 

 

If they have 2,000 expected hours they need to work 80%, if they have less then 2,000 they need to work their percent of hours. 

 

I have a column that lets me know the expected hours. and the percent of hours if not 2,000. 

 

I created an if measure however it didn't work.

 

 

 

Below is the Chart of data I have.  

 

 

 

  • Is your data types correct? You are comparing text '2000' to integer? Also, we do not see your measure in your matrix where is it being used? How do we know it's not working? Please provide sample data, not an image.

1 Reply

  • ChrisMendoza's avatar
    ChrisMendoza
    Icon for Resident Rockstar rankResident Rockstar

    Is your data types correct? You are comparing text '2000' to integer? Also, we do not see your measure in your matrix where is it being used? How do we know it's not working? Please provide sample data, not an image.