You are viewing limited content. For full access, please sign in.

Question

Question

Discount calculation for specific selections

Forms
Updated July 19, 2021
asked on June 23, 2021

I'm working on a form where the application fee will change based on the selection. I've figured out quite a bit of it, but when two options (there are 10 total) are selected than there is a discounted price of 500$. There are three different combination of two items that get this discount. I tried doing this with field rules, but whenever I "ignore the data" it's still used in my calculation. Is there a way do make this into a formula? Maybe using SumIf? 

0 0

Replies

replied on June 29, 2021

Could you provide more information regarding the fields? Maybe a screenshot of the fields in question. 

0 0
replied on July 5, 2021

I've added a screen shot of the list below. Applicants can choose any number of items form the list, but when the coloured coordinated highlights are combined there's a 500$ discount. 

Essentially whenever any of the following combinations are made, I want there to be an additional discount subtracted from the total. 

OCP + Dual Zoning Bylaw Amendment

Land Use Bylaw + Zoning 

OCP + Zoning Bylaw Amendment

 

 

0 0
replied on July 7, 2021 • Show version history

I would create a field which is always hidden and performs a calculation. 

From the screenshot it is difficult to tell if you are using a table or individual fields. 

Either way a function can be created like so:

IF(VariableName = "Official Community Plan (OCP) Amendment", IF(VariableName = "Zoning Bylaw Amendment", 500, IF(VaribleName = "Dual Zoning Bylaw Amendment", 500, 0)), IF(VariableName = "Land Use Bylaw Amendment", IF(VariableName = "Zoning Bylaw Amendment", 500, 0), 0))

 

If the fields are within in table be sure to include the table name as well as the variable when referencing them like so.


TableName.VariableName 

 

The value of this hidden field can later called when calculating the total of the form cost. Simply subtracting the variable value from the total cost.

0 0
replied on July 19, 2021 • Show version history

 I've tried your formula, but nothing seems to calculate when I select one of the combinations. I've left the calculation viewable and it just doesn't show anything at all. Here's my formula, did I miss something? 

 

=IF(PlanApps.PlanType = "Official Community Plan (OCP) Amendment", IF(PlanApps.PlanType = "Zoning Bylaw Amendment", 500, IF(PlanApps.PlanType = "Dual Zoning Bylaw Amendment", 500, 0)), IF(PlanApps.PlanType = "Land Use Bylaw Amendment", IF(PlanApps.PlanType = "Zoning Bylaw Amendment", 500, 0), 0))

 

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...