Forum Discussion

rathimd's avatar
rathimd
Frequent Visitor
3 years ago
Solved

Calculate column returning multiple values in if condition

Hi ,   1) Using Column  When I am passing column else condition in below query it is giving returing me single value. Mark-up Cost Actual - Salary = IF(      RELATED(          Employees[Rank C...
Need Help
Show and Tell
  • amitchandak's avatar
    amitchandak
    3 years ago

    rathimd , try like

    IF(
    Max( Employees[Rank Code] ) = 9050,
    DIVIDE(
    SUM('Time & Billing'[PROD_TIME_AMT]),
    SUM('Time & Billing'[PROD_TIME_HRS])
    ),
    [Labor Rate Salary])

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    rathimd , try like

    IF(
    Max( Employees[Rank Code] ) = 9050,
    DIVIDE(
    SUM('Time & Billing'[PROD_TIME_AMT]),
    SUM('Time & Billing'[PROD_TIME_HRS])
    ),
    [Labor Rate Salary])