cul8ter
Members
Content Count
30 
Joined

Last visited
Community Reputation
0 NeutralAbout cul8ter

Rank
member
 Birthday 05/10/1970

field numbers with decimal point
cul8ter replied to cul8ter's topic in Calculation Engine (Define Fields)
Oh Yeh, we party an extra 5 days each year. Well, 2 days of party and 3 days to recover. 
field numbers with decimal point
cul8ter replied to cul8ter's topic in Calculation Engine (Define Fields)
I know 30 days is not a month but our laws in nevada pertaining to my business is based on a 360 day year, therefore 30 days is a nevada month. only in vegas!! 
field numbers with decimal point
cul8ter replied to cul8ter's topic in Calculation Engine (Define Fields)
the original invoice date is in 1 field, then when a payment record is created i need 30 days from that date to compute automaticaly in the second field, wich would be next payment due date. 
is your odbc, and web sharing turned on?

field numbers with decimal point
cul8ter replied to cul8ter's topic in Calculation Engine (Define Fields)
I am trying to get an automatic date to fill a feild when i creat a new record. I have a field that has a certain date in it, let's say 01/01/2009, now when i create a new record for payments i need the second field to automatically change to exactly 30 days,IE;01/30/2009 when i create a new payment record. any ideas?? 
field numbers with decimal point
cul8ter replied to cul8ter's topic in Calculation Engine (Define Fields)
I am not sure how to do that, 
lets say I have a small number in a field let's say $37.50. I cannot get the number to break down with the decimal point it always comes out as 3750 without the decimal. I have tried number format but cannot figure this one out, does any one have any ideas. Jimmie

i have used this formula it is a general layout but you can change the numbers to work for you. Case ( Field1 ≥ 200 ;Case (Field1 ≤ 1000 ; 17 ; Field1 ≤ 3000 ; 9 ;Field1 ≤ 6000 ; 6 )) James

Recording date of new record and reecord changes
cul8ter replied to hstierho's topic in Calculation Engine (Define Fields)
Mr Vodka is correct I have that set up in my Filemaker 7 when a new record is created it automayically assigns the date it was created and when ever anyone makes a change to that record i have another field wich shows me who changed it what date it was changed and what time it was changed. James 
Thanks Jouneyman, i may just need to keep playing around with it until i get i figured out, i think it's more simple than i am making it out to be, i don't know, because of that it is frustrating me.

Hello, I have several fields that i am able to add up for a total, such as principal + intrest = x amount, but i am having a hard time trying to figure out a payoff associated with dates. IE client made payment on 03/07/2008 and has $1,000 in the principal field and lets say a payment of $100 for next months payment due, but lets say they payoff early by a few days, say 28 days i have a field that divides by 30 to get the daily rate but would like to be able to put in a date in a field that would click on a tab and have it show the exact payoff for whatever date they want to payoff. I have t

Calculation within a newly created record. In field 1 i input $1,000. and in field 2 i need for the interest rate of that field to equal a percentage of what is in Field 1 IE; 1,000 times 16% equals 160. or it could be 3,000 in field 1 and 8% of Field 1 or any variations of numbers because there not all the same. any ideas?

Calculation for variable number
cul8ter replied to cul8ter's topic in Calculation Engine (Define Fields)
Calculation within a newly created record. In field 1 i input $1,000. and in field 2 i need for the interest rate of that field to equal a percentage of what is in Field 1 IE; 1,000 times 16% equals 160. or it could be 3,000 in field 1 and 8% of Field 1 or any variations of numbers because there not all the same. any ideas? 
Calculation for variable number
cul8ter replied to cul8ter's topic in Calculation Engine (Define Fields)
It worked, thank you so much, I have another one for you now that issue is resolved. In field 1 i input $1,000. and in field 3 i need for the interest rate of that field to equal a percentage of what is in Field 1 IE; 1,000 times 16% equals 160. or it could be 3,000 in field 1 and 8% of Field 1 or any variations of numbers because there not all the same. any ideas? 
Calculation for variable number
cul8ter replied to cul8ter's topic in Calculation Engine (Define Fields)
I need to be more clear. I create a new record, and in field 1, i input a number between $200 to $1,000. when i click off the screen i need the number 17 to pop up in the second field.also an amount between $1,001 to $3,000 to input 9 in the second field. and 3,001 through 6,000 in the first field to have 6 pop up in the second field, you get the Idea. this needs to be a calculation but i cannot get my attempts to work, any Ideas? Thank you