kemseakeiron

0 Quantities on Sub Summary parts and GetSummary calculations

Discussion created by kemseakeiron on Jan 8, 2019
Latest reply on Jan 13, 2019 by kemseakeiron

Hi all, I have a report with a summary of transaction quantities.

 

When we have a transaction in of 100 we get +100, and out 100 we get -100, resulting in a total of 0.

 

Problem is two-fold.

 

1. On other reports, I seem to be able to hide the ZERO's based on a get summary auto-calculation. For this particular report, it doesn't want to work. Despite being an identical copy of the other. (just a different field displayed)

 

2. I can generate a report using a summary from a parent table to omit 0 results. However, this is extremely slow.

 

Any suggestions on how I can hide these zero sub summary results?

Everything on other threads is either extremely slow or not functioning as expected.

 

 

Report with 0 showingKSI Report 0.PNG

 

 

layout

KSI Report 2.PNG

 

 

Report that hides the 0:

KSI Report 3.PNG

 

layout:

KSI Report 4.PNG

 

Am I missing something simple?

Outcomes