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...
