My database has run well for 3 months but now I need to change the discount structure. I have added a Column and called it Qtr and each record will be either 1,2,3,or 4 the idea being that the discount offered for that Qtr could be different.
So far...
I currently have the following formula running since January that I want to be active for all bookings up to up the end of Mar 2021.
{Extrachildren} * MIN(({Weeks FM/Zoom}+{WeeksSR}), 10) * 5
For April until June I want this formula to be active
{Ext...
I currently have a formula that calculates the cost of a child attending a class over a number of weeks.
Extrachildren*({Weeks FM}+{WeeksSR})*5
This works well until I was told if they book for 11 weeks then the 11th week is free (they never book for...
I have a formula that correctly shows the cost of having 1 child in a class. When the parent has 2 or more children the cost is £5 per extra child per week.
They could be in either Weeks FM or WeeksSR.
So far I have a column showing “extraChildren” /...
I have a lookup option (in Number of weeks) that has two different values. I want to be able to extract the numeric value from either of the text strings that is chosen and place that value in the AMOUNT column but I have no real idea as to how to do...
I know I had to be spoon fed but I can’t tell you how much I appreciate the time and effort you have put in with me.
Naturally your last answer has saved correctly and even calculated correctly.
You will not be surprised but I am certainly relieved.
...
I do really appreciate how you are trying to teach me. I am just aware how much of your time I am taking when it is unlikely at 73 I will ever do another database, I certainly will not say I can help my niece again!!! Thats not strictly true but I am...
At last the first of the SWITCH calculations is working.
I have now tried to enter the second of the discount structures but it doesn’t save so yet again I am doing something wrong but I have no idea as to what.
Is there anybody who can point out t...
Now mid afternoon and I have the following formula that does save.
SWITCH( {Qtr},1,({Extrachildren}* MIN(({Weeks FM}+{WeeksSR}), 10) * 5))
Unfortunately that is all it does.
The column is completely blank.
In theory I would have thought that as I a...
