Another great place to start is to pick one of the formulas that says #value and hit the fx button on Excel's formula bar to launch the Excel formula wizard.
Do all the evaluated arguments look correct? (are any blank, or errors?)
PA for Excel has error logging you can switch on (it's in the options screen from our ribbon), if you do that, and then execute your test - failure details will be logged to a file.
------------------------------
Ted Phillips
------------------------------
Original Message:
Sent: Tue June 09, 2020 12:37 PM
From: Tarissa Mellin
Subject: PAX Recalculate Book Causes #VALUE!
In PAX, I've built a custom report. When I select "Recalculate Book" for a refresh, it errors out my DBRW formulas, but there are no errors on the dimension formulas (SUBNMs). Any idea if this is a PAX version bug or how to fix?
------------------------------
Tarissa Mellin
------------------------------
#PlanningAnalyticswithWatson