Hi I'm trying the trial version of Dynamic Forms to see if I can get it to accomplish my task, I've been able to get it to do a simple calculation, but I am stuck on combining values in a second calculation. Here's what I am trying to accomplish (short name in parenthesis):
Fields:
Number of Nights (Numbero) //Combo Box
Rate (Rate) //Text Field
Sub Total (SubTo) //text field
Cleaning Fee (Cleaning) //text field w/static value
Tax (Tax) //text field w/static value
Grand Total (GrandTo)
I need to process the following calculation:
((Numbero * Rate) + Cleaning) * Tax = GrandTo
Right now I have the following in the client side events fields:
Numbero:
$(SubTota) = parseInt($(Numbero)) * parseInt($(Rate))
Rate:
$(SubTota) = parseInt($(Numbero)) * parseInt($(Rate))
SubTo:
$(SubTota) = parseInt($(Numbero)) * parseInt($(Rate));$(GrandTo) = parseInt($(SubTota)) + parseInt($(Cleaning)) * parseInt($(Tax))
Cleaning:
$(SubTota) = parseInt($(Numbero)) * parseInt($(Rate));$(GrandTo) = parseInt($(SubTota)) + parseInt($(Cleaning)) * parseInt($(Tax))
Tax:
$(SubTota) = parseInt($(Numbero)) * parseInt($(Rate));$(GrandTo) = parseInt($(SubTota)) + parseInt($(Cleaning)) * parseInt($(Tax))
GrandTo:
$(SubTota) = parseInt($(Numbero)) * parseInt($(Rate));$(GrandTo) = parseInt($(SubTota)) + parseInt($(Cleaning)) * parseInt($(Tax))
The SubTo field is calculating correctly, but I cant get the GrandTo field to calculate.
Can you help?
Thanks,
Brian