I am rather new but learning quickly. My most complex task is to create a daily bar chart showing the shift close imbalance of a restaurant. This to be used to check up on employees.
The formula is cash_in via sales - amt_paid_out + shift start amt - shift close amt
Each of the terms is a separate field in the sqllite table. I can easily constuct four bar charts representing each term of the formula, but to be useful, the four terms need to be combined to render the single value of shift_close_imbalance, which can be plus or minus number by the way.
Any ideas? I think what i can learn on this one will give me all the tools i need to create my report library
thanks in advance