How to calculate percentage
-
I have 3 options.
Number of bedrooms – fieldname3
Number of bathrooms – fieldname4
Frequency (weekly, bi weekly, monthly) – fieldname6 – these are % off. Weekly is 20% off for this example.and then it displays the total – fieldname1
I need it to add fieldname3 and fieldname4, then take fieldname1 which is the result number from those two, and find what the fieldname6 numbers % is, so for this example 20 is the digit, so it needs to find out what 20% of fieldname1 is, then minus that number since its 20% of the total cost discount.
I am struggling to figure it out. I tried to do it this way.
(fieldname3+fieldname4)-(fieldname1*fieldname6/100)
But this does not calculate the correct number.
Can someone help me please =]
- The topic ‘How to calculate percentage’ is closed to new replies.