You’re offline. This is a read only version of the page.
141
I'd like my project invoice to not print types (hours, items, expenses, etc) that have no transactions. Currently it's just printing everything and having amounts 0.00 in place. I've used a bunch of different functions and data sources in the Enabled field but my invoice export is completely refusing to pick it up and work according to it.
I've done testing as well to see what values the count function prints for various data sources, and then constructing my functions accordingly to ensure the block doesn't print in my invoice, but I think at this point in my experimenting it's not about what data sources I'm using, it's just that the report is NOT looking at that Enabled field at all.
Is there something I'm missing please?
I figured it out!
The named ranges in my attached document (Excel in my case) MUST be entire rows e.g. $1:$5 and not a block like $A1:$C5.
Because I named my hours/items/expenses ranges by the block ($B4: $H10), the cells on the sides of that block in Column A and Columns I onwards to the left are still being "printed" and thus cannot be hidden.
ER formatting works row by row and doesn't fully support named ranges that are side by side.
Share
Report
All responses (
Answers (
