Forum Discussion

Grande's avatar
Grande
Frequent Visitor
5 years ago
Solved

If statement not working

Any help appriciated.. getting ERROR message with below condtion   P1 = IF(VW_ORT[Partime_Num.?] = 2, DIVIDE (VW_ORT[Annual Salary (Local Currency)], IF(VW_ORT[Partime_Num.?] = 1,(VW_ORT[Annual Sa...
Need Help
  • CNENFRNL's avatar
    CNENFRNL
    5 years ago

    Grande , it looks like you are authoring a measure, aren't you? If so, you might try,

     

    P1 =
VAR __pt = MAX ( VW_ORT[Partime_Num.?] )
VAR __as = MAX ( VW_ORT[Annual Salary (Local Currency)] )
RETURN
    IF ( __pt = 2, DIVIDE ( __as, IF ( __pt = 1, __as ) ) )

     

Grande's avatar
Grande
Frequent Visitor
5 years ago

I would like to creted the below formaula for the which is giving me error Please help me..

 

Annual Salary (USD) - AOP FX Rates + (Annual Salary (USD) - AOP FX Rates * Fringe Rate)

Excel Formula =IFERROR(BR31765+(BR31765*BP31765),"NA")

data Values : 

 Fringe Rate = 15%
AOP FY20 FX Rates = 1
Annual Salary (USD) - AOP FX Rates = 152,360
Annual Salary + Benefits (USD) = 175,774 

 

I created the formula but it does not giving me the correct Results 

I should get the Result = 175774

 

 

Please help me