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.
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: