Table A is constantly changing on a weekly basis, whereas Table B will have records of date and sum. E.g.
and so on, so we have a trend of a weekly value
I'm having a difficult time writing an IF statement in Advaned Editor to see if today's date already exist, then ignore, if today's datedoes not exist, then calculate sum in Table A and create a new row in Table B.
I'm sure this could be resolved in the backend but it's what I have at the moment.