I have an application that shows all the invoices by customers putting in the correct columns, if the invoice is open for a future due date, or if it is late 30, 30-60, 60-90 or more than 90 days.
I had to put a variable field where my user puts a date and I have to use this date as a cut date, so in the dinamic table, I have to calculate on line if the invoice is open or not and in which column the value will appear, according to the cut date variable.
All of this is OK after a hard work, but in the dinamic table I had a lot of invoices that are not open and they appears with no values. I would like to know a way to eliminate those invoices of the dinamic table, remembering that I only know if they are open or not during the on-line calculation.
Your Amount Document Expression column is preventing your 0 values from rolling up. Since those values are greater than zero, Suppress Zero Values has no effect.
In order to fix this, I would set a conditional on that field and only populate it when the Amount Open is greater than 0. I have attached an example, but it may not be exactly what you need. My expression sets that field to 0 if the formula for Amount Open is 0.
Another option would be to put that field in as a dimension (if possible) instead. That way, if all the expressions are zero, the record would be suppressed.
Your Amount Document Expression column is preventing your 0 values from rolling up. Since those values are greater than zero, Suppress Zero Values has no effect.
In order to fix this, I would set a conditional on that field and only populate it when the Amount Open is greater than 0. I have attached an example, but it may not be exactly what you need. My expression sets that field to 0 if the formula for Amount Open is 0.
Another option would be to put that field in as a dimension (if possible) instead. That way, if all the expressions are zero, the record would be suppressed.
