Forum Discussion

Koli's avatar
Koli
Frequent Visitor
2 years ago
Solved

Reconciling 2 Data Sets

Hello,

 

I hope all is well. I am trying to reconcile 2 different data sets. One of the problems I am running to is rounding and conditional formatting.
For example:

Sum of Amount          2nd Amount

$130.00                             $129.99998

 

Essentially these are the same numbers with rounding

 

I would like the conditional formatting to read .. if sum of amount is almost the sum of the 2nd amt then place remark, else null. 

I know that's not the correct operator. However this is what I'm trying to get to. Is this possible?


Thank you!

 

  • Koli's avatar
    Koli
    2 years ago

    Hello,

     

    Thank you for responding. I was able to figure it out. I used conditional formatting,

    if AF variance is less than or equal to zero then rounding.

     

    Thank you!

12 Replies

    • Koli's avatar
      Koli
      Frequent Visitor

      Thank you for the information. Would this be placed in conditional formatting or hardcoded in the editor function line of Power Query?