7 - App Architect
since ‎Sep 21, 2017
‎Nov 29, 2022

## User Statistics

• 45 Posts
• 1 Solutions
• 5 Kudos given
• 16 Kudos received

## Is this a case for an IF statement?

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

## Changing discount at the end of three month period

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

## Amend a Formula to cater for a discount

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

## Simplifying and completing a formula

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

## Extracting Numeric Value from Text

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...
Kudos from
Kudos given to