Re: Mulitply multiple variables within text object
I can't share it unfortunately
For example, this is my chart:
If I then input figures for April and May you can see that the number of people have increased from 2,642 to 3,162, which is what i am expecting, however the cost has only increased based on the increase in people for April and not April AND May (=money(sum(if(len(SERVICE_PROVISION_18_PERSON_DESC)>1, FIN_WKLY_COST)) +
vClientAverageWeeklyCost * Apr)) as I dont know how to edit my expression to include the months for the rest of the year.