Forum Discussion

vjnvinod's avatar
vjnvinod
Icon for Impactful Individual rankImpactful Individual
6 years ago
Solved

Calculated coloumn error

hi   i am getting below error, can you help?  
Need Help
Show and Tell
  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    Hi vjnvinod ,

     

    Here is the syntax of IF() function:

    IF(logical_test>,<value_if_true>, value_if_false)

     Now your ture value is a TRUE/FALSE formula, this is why the error occurs. I think you want two conditions, you could use AND(condition1,condition2) or condition1&&condition2 to combine your conditions.

     

vjnvinod's avatar
vjnvinod
Icon for Impactful Individual rankImpactful Individual
6 years ago

amitchandak 

 

didn't follow your logic, can you correct the below measure & help me understand.

 

Column = IF(DataDumpFull[ReverseVsMercurry]="Not a reverse", DataDumpFull[ActualChrdHours]=ABS(DataDumpFull[ActualChrdHours]),ABS(DataDumpFull[ActualChrdHours]*-1))
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Column = IF(DataDumpFull[ReverseVsMercurry]="Not a reverse" && DataDumpFull[ActualChrdHours]=ABS(DataDumpFull[ActualChrdHours]),ABS(DataDumpFull[ActualChrdHours]*-1,0))