This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hi
Has anyone worked out how to make a line chart that shows cumulative sales?
Each record in my table has an amount of sales assigned to it and a date but on a line graph the graph shows the number of sales but not the acummulating number of sales.
...
Hi there, Im looking for a bit of help with a formula. I’ll try and explain it as best I can…
I have six fields as follows:
1st Payment Date (date type) (e.g 1st Jan 2020)
1st Payment Amount (Currency) (e.g £500)
2nd Payment Date (date type) (e.g ...
I would change the dates accordingly for 2021, the dates above are just an example.
I cant put date ranges (basically collecting expenditure across a month) in the each payment date field as their set payment dates, or am I misunderstanding what you ...
Hi Jeremy
Thanks for responding.
I’ve been trying to define the date range in a formula field using a combination of IF, AND, IS BEFORE and IS AFTER. This is as far as I’ve got so far, but I know its wrong as it doesn’t work:
SUM(IF(AND(IS_AFTER({1s...
