Forum Discussion
Analysis Services: Negative values are not supported
Hi RemiAnthonise ,
You could try the function of ISERROR to catch those data.
IF( ISERROR(
SUM('ResellerSales_USD'[SalesAmount_USD])
/SUM('InternetSales_USD'[SalesAmount_USD])
)
, BLANK()
, SUM('ResellerSales_USD'[SalesAmount_USD])
/SUM('InternetSales_USD'[SalesAmount_USD])
)Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi v-xuding-msft Xue,
I'm not sure where it goes wrong. Maybe in my report but like I said: I do some calculations in Analysis Services / SSAS. With the error-message I can't see where it goes wrong as it is not mentioning where. So it can be in my report or in SSAS.
Other strange thing: I don't get it every time I do a refresh. It looks pretty random whether it works or not.
Sometimes my refresh goes well and it's completed without errors. I don't know where and when it goes wrong but for now it looks allright. I successfully uploaded my report to our Report Server and Scheduled Refresh works so for now it looks allright.
It's weird. You didn't change anything but it works fine now. Still glad that you can upload and refresh the report. If you encounter that error again, feel free to post here.
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.