1 Reply Latest reply on Jan 16, 2012 10:34 AM by philmodjunk

# I have been pulling my Hair out over this seems to be so easy Calculation HELP!

### Title

I have been pulling my Hair out over this seems to be so easy Calculation HELP!

### Post

Alright Here is what i have , I have a Layout that includes to following items

1) Billing Type                        2) Contract Amount                        3) Billing total

Weekly                                    A Number                                    Answer= Contract Amount / 52

Monthly                                   A Number                                    Answer= Contract Amount/12

Quarterly                                 A Number                                    Answer= Contract Amount/4

Semi - Anually                          A Number                                    Answer= Contract Amount/2

Yearly                                      A Number                                    Answer= Contract Amount

Where Billing Type Is a single Drop Down selection box , Contract amount is a single a user input , and currenly i have 5 fields set up for the answers where i just have set up a calculation for each answer field to take the contract amount number and devide it for the amount i need.

What i would like to do is go to a Single Billing type (Which i currently have useing a Custom Value list) , A Single Contract amout Box (which i have as user inputed) and then have a single Billing Total Box which its answer is determinied by a calculation that looks at the Billing method and the contract amount  which would determine the approperate calculation and input it into the single Billing amount box.

Example

Billing Type = Weekly               Contract amount = \$5,200.00    Billing Total = \$100.00

No matter what i try works , I would think it would be such a simple process but its driving me insane .

I Tried using a Nested Calculation But apperantly I have Absolutly no Good understanding on writing it cause it absolutly failed to work

HELP!!!

• ###### 1. Re: I have been pulling my Hair out over this seems to be so easy Calculation HELP!

Contract Amount / Case ( BillingType = "Weekly" ; 52 ;
BillingType = "Monthly" ; 12 ;
BillingType = "Quarterly" ; 4 ;
BillingType = "Semi - Anually" ; 2
1 )