03-02-2018 10:02 AM
Report shows '--' instead of the percent. But when you export the report, percent shows up in Excel when using SUM in the formula field. When it looks like this "${TotalNotReadyTime}/${TotalLoginTime}" it worked fine showing the values as expected. When it looks like this,"${TotalNotReadyTime}/SUM(${TotalLoginTime})", it gives '--' in the report . Calculation results still work either way when viewed in the export.
03-04-2018 09:45 PM
Hi Regina,
The " --" is shown if the formula results in a "Divide by Zero" error.
I suggest you open a case to look into this.
Thanks,
Vikram G
03-05-2018 05:16 AM
Interesting. I opened a case and they sent me here.
03-05-2018 07:11 AM
Sorry for that ! As I mentioned earlier if we have a denominator as 'zero', it will lead to a divide by zero and hence we show a "--".
Can you check why your denominator is zero?
Thanks,
Vikram G
03-05-2018 08:16 AM
03-06-2018 08:44 PM
Hi Regina,
I suggest you please push TAC to escalate the case to the BU. we will need to analyze this further.
Thanks,
Vikram G
03-07-2018 02:38 AM
Thanks. I have and they told me to apply ES04(COP04). I am working to get that patch applied and test again.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide