Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
In my report I have a table with multiple columns among which I have a column "Send".
In this column "Send", if the invoices not being sent, I have the value "-", otherwise I have the date when the invoices was sent.
In this report I have other graphs (stacked bar ...).
I sometimes want to have only the invoices that were not sent and sometimes the invoices that were sent and sometimes all the invoices (sent and not sent).
For this, I filter on the column "Send" on the table by choosing "-" to have the invoices that were not sent and everything except "-" to have the invoices that were sent.
All the graphs are updated.
I want to add in my report theses values
- All
- Sent
- Not sent
When I click to "Not sent" I have the same result when I click in the table on column "Send" by choosing the "-"
....
Thanks you for your help !
You want to add three fields in the script?
All
Sent
Not Sent
You can create these three fields in their respective table of the script:
Maybe you have problems with '-' and you need to use isnull()
Thank you.
You want to add three fields in the script?
All
Sent
Not Sent
You can create these three fields in their respective table of the script:
Maybe you have problems with '-' and you need to use isnull()
Thank you.
Hi,
Thanks for your response.
I want when I click on "Sent", I have the same result when I select all my rows except "-" in my table.
For example I have another graph
When the value is "Sent" the formula is : "avg(date 1 - date 2)
When the value is "Not send" the formula is : "avg(date 3 - date 4)
I must create two columns ? A column with "All" for all rows, A column with "Sent" or "Not send" ?
Yes.