Getting a #NUM! error when adding a calculated column to the Sum RRS feed

  • Question

  • I'm using PowerPivot for a report. It's a sales report, but it is in pesos. I added a calculated column so I can divide the Amount column by the exchange rate of that day, and obtain the Amount in USD. For some reasons when I add that new field to the Sum section of the PivotTable all I get are #NUM! errors. There has to be a way to display/sum those in PowerPivot, otherwise what's the point?

    Anyone know what I'm missing or doing wrong?

    Thanks a lot,


    Wednesday, May 28, 2014 12:37 PM


  • So, I finally solved it by accident.

    First I tried adding a ISERROR function, but that didn't solve it.

    Then, I saw this little button I hadn't noticed before in PowerPivot which said Mark as Dates Table (or something like that -- Excel interface is in Spanish) -- and behold, suddenly my calculated columns worked! Ta-daaaaah!

    Hope can help somebody!

    • Proposed as answer by Michael Amadi Thursday, May 29, 2014 3:37 PM
    • Marked as answer by Charlie Liao Monday, June 2, 2014 9:06 AM
    Wednesday, May 28, 2014 12:48 PM