Hi everyone
I was wondering how do I get the the title (hightlighted in bold) to replace the Total (in red) in the each section of data or at least putting the heading on the same line with the total?
In the CSV file we receive, it groups type of data together, what I need it the total amounts, for invoicing purposes. (I had a thought of something like everytime you have a blank line do this???)
I hope I have explained it well enough.
Thanks in advance.
I was wondering how do I get the the title (hightlighted in bold) to replace the Total (in red) in the each section of data or at least putting the heading on the same line with the total?
In the CSV file we receive, it groups type of data together, what I need it the total amounts, for invoicing purposes. (I had a thought of something like everytime you have a blank line do this???)
I hope I have explained it well enough.
Thanks in advance.
__MPS Packed Patient Days__ | |||||||||
Ward | Bulk Order Days | @ | Total | CD Bulk Order Days | @ | Total | CD Mixed Bulk Order Days | @ | Total |
A1 | 889 | 0.01 | 8.89 | 0 | 0.01 | 0 | 0 | 0.01 | 0 |
A2 | 455 | 0.01 | 4.55 | 0 | 0.01 | 0 | 0 | 0.01 | 0 |
A3 | 630 | 0.01 | 6.30 | 28 | 0.01 | 0.28 | 0 | 0.01 | 0 |
A4 | 532 | 0.01 | 5.32 | 0 | 0.01 | 0 | 0 | 0.01 | 0 |
A5 | 21 | 0.01 | 0.21 | 0 | 0.01 | 0 | 0 | 0.01 | 0 |
Total | 2527 | 25.27 | 28 | 0.28 | 0 | 0 | |||
__Courier Fees__ | |||||||||
Date | Cost | ||||||||
TOTAL | 0 | ||||||||
__Fractional Tablets__ | |||||||||
FractionsWithoutAlternative | FractionsWithoutAlternativeFee | FractionsWithAlternative | FractionsWithAlternativeFee | ||||||
1616 | 0.01 | 0 | 0.01 | ||||||
__Chart Care__ | |||||||||
Signing Sheets | Pages | Summary Sheets | Pages | NRMC Sheets | NRMC Pages | Fee | NRMC Fee | Total | |
Aged Care by MPS | 0 | 0 | 0 | 0 | 0 | 0 | 0.10 | 0 | 0 |
Community by MPS | 0 | 0 | 0 | 0 | 0 | 0 | 0.10 | 0 | 0 |
Aged Care in Pharmacy | 0 | 0 | 1 | 4 | 0 | 0 | 0.10 | 0 | 0.2 |
Community in Pharmacy | 0 | 0 | 0 | 0 | 0 | 0 | 0.10 | 0 | 0 |
Totals | 0 | 0 | 1 | 4 | 0 | 0 | 0.2 | ||