Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Formula returning Incorrect result

Can anyone explain why am I getting an incorrect result in some of the rows (Progress_Status_V_Baseline) like the one highlighted (row 59)? 

Any sugestion of how to fix it, as I am then getting wrong % when analysing the data.

 

Thanks guys

 

 

 

Need Help
  • v-jingzhang's avatar
    v-jingzhang
    4 years ago

    Hi Anonymous 

     

    Please try this code. Use Number.RoundDown or Number.Round to round the result of ([Improvement]+[Baseline_ToFill]) to have a specifc decimal digits. Based on my test, specifying the digits number to 1/2/3/4/... will all bring you the correct result. 

    = Table.AddColumn(#"Added Custom", "Custom.1", each if [Value] = -1 then "-" else if [Value] < Number.RoundDown([Improvement]+[Baseline_ToFill],1) then "Below" else "Meet or Above")

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

9 Replies

  • BA_Pete's avatar
    BA_Pete
    Super User
    4 years ago

    Hi Anonymous ,

     

    Can you share the calculation you're using to generate the [Progress_Status_V_Baseline] column please?

    Your screenshot only shows the [Progress_Status_V_Target] calculation.

     

    Pete

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi BA_Pete = Table.AddColumn(#"Filtered Rows", "Progress_Status_V_Baseline", each if ([Value] = -1) then ("-") else if ([Value] < ([Baseline_ToFill] + [Improvement])) then ("Below") else ("Meet or Above"), type text)

      • mahoneypat's avatar
        mahoneypat
        Microsoft Employee
        4 years ago

        Your result seems correct, as 9.6 is <= 10.2 and should result in "Below". What is the issue?

         

        Pat