Howdy, Stranger!
It looks like you're new here. If you want to get involved, click one of these buttons!
Quick Links
Data Model could not be accessed
Hello,
I've been running the Portfolio Slicer 2013 with just uploading 3 transactions, one for Symboltransferin, one for dividend and one for partial sale of stock, but I'm getting this calculation error each time
"The query did not run or the Data Model could not be accessed. Here's the error message we got: MDxScript(Model) (7, 40) Calculation error in measure 'Report'[Profit %]: An Argument of function 'LN' has the wrong data type or the result is too large or too small."
I'm not sure what is wrong, but the "Yearly", "Holdings" tabs are not updating.
Any advice on how to fix this?
I've been running the Portfolio Slicer 2013 with just uploading 3 transactions, one for Symboltransferin, one for dividend and one for partial sale of stock, but I'm getting this calculation error each time
"The query did not run or the Data Model could not be accessed. Here's the error message we got: MDxScript(Model) (7, 40) Calculation error in measure 'Report'[Profit %]: An Argument of function 'LN' has the wrong data type or the result is too large or too small."
I'm not sure what is wrong, but the "Yearly", "Holdings" tabs are not updating.
Any advice on how to fix this?
Comments
Usually this error indicates that calculated "Profit %" does not make sense. For example you have holdings, but no quotes for one month, so you have 100% loss one month and then from 0 you suddenly have holdings that were not there. Check these transactions and make sure you have quotes for symbols. If you cannot figure out, you can send me your Excel workbook and PSData folder files, my email is posted on this page:
http://www.portfolioslicer.com/contact.html