bmen Posted April 17, 2006 Share Posted April 17, 2006 hello, last post seems to have disappeared. newbie here i am trying to set up a column which has % calculation in it but problem is i want different % values in each record currently i get same value in all records. i have set this in data base define as f3*.12 which gives me 12% but as i said i want differing values per record obviously im doing this wrong jacky Link to comment Share on other sites More sharing options...
-Queue- Posted April 17, 2006 Share Posted April 17, 2006 I had merged your duplicate posts (which are poor etiquette) into a single thread in the appropriate forum, but for some reason, all evidence of it vanished. Sorry about that. Anyway, check that f3 and/or the calculation field is not set as a global in the Storage options for the field. Link to comment Share on other sites More sharing options...
bmen Posted April 17, 2006 Author Share Posted April 17, 2006 yes sorry about duplicate i had initially used wrong forumn. am i using correct data entry as in define data base or should i be somewhere else? Link to comment Share on other sites More sharing options...
-Queue- Posted April 17, 2006 Share Posted April 17, 2006 Yes, in Define Database, select each field and then check the Storage tab for it. Link to comment Share on other sites More sharing options...
bmen Posted April 17, 2006 Author Share Posted April 17, 2006 hello. global storage is cleared i have set up like this column scrap(F3) records abc want this to read 10% of qty in F4 records def " " " " 5 % of qty in f5 records ghi " " " " 15% of qty in f6 hope this helps Link to comment Share on other sites More sharing options...
-Queue- Posted April 17, 2006 Share Posted April 17, 2006 Sorry, but I am not understanding what you are saying. Perhaps you could zip and attach a sample of the file with a few notes to clarify which field should do what. Link to comment Share on other sites More sharing options...
bmen Posted April 17, 2006 Author Share Posted April 17, 2006 ok will do but it will be tomorrow eve now its 00. 26 in uk and im going to bed Link to comment Share on other sites More sharing options...
bmen Posted April 18, 2006 Author Share Posted April 18, 2006 hello I have the file ready zipped but cannot get manage files to open to attach it Link to comment Share on other sites More sharing options...
-Queue- Posted April 18, 2006 Share Posted April 18, 2006 Click Preview instead of Add Post. You will then see the option to attach files. Link to comment Share on other sites More sharing options...
bmen Posted April 18, 2006 Author Share Posted April 18, 2006 hello Link to comment Share on other sites More sharing options...
bmen Posted April 18, 2006 Author Share Posted April 18, 2006 hello,i haveattatched a zip of the sample file F7 is the column i want the % value to be placed in from values in F1. these values have to be variable and this is what i am unable to do I can only get the same % in all the column crc_stock.zip Link to comment Share on other sites More sharing options...
bmen Posted April 18, 2006 Author Share Posted April 18, 2006 sorry values are to be from F3 not F1 Link to comment Share on other sites More sharing options...
-Queue- Posted April 18, 2006 Share Posted April 18, 2006 Try using another field to contain the desired percentage for each record and a calculation field to determine which field should be multiplied by the percentage in the given record. I have no idea what your criteria would be or else I would provide a sample Case( ) statement. Link to comment Share on other sites More sharing options...
bmen Posted April 18, 2006 Author Share Posted April 18, 2006 hi, the criteria is that each record would display a % of the incoming total(f3)in the F7 column That % would need to be set in each individual record ie.1st record perhaps 5% next at say 8% of incoming F3...IF IT WAS 100 in F3 then 8 in f7 column Sorry to be a nuisance on this but it is driving me up the wall jacky Link to comment Share on other sites More sharing options...
-Queue- Posted April 18, 2006 Share Posted April 18, 2006 And how is the percentage determined? If it is manually set, then add a field to hold it, then multiply that field by f3 for your total. If it is determined via calculation, then what is the calculation you are using? Link to comment Share on other sites More sharing options...
bmen Posted April 18, 2006 Author Share Posted April 18, 2006 hi again, ideally I would like to type in a value that would remain until i manually over rode it i.e if i initially set value at 8% it would normally remain that for many weeks if not months The data base is to determine actual stock level with the estimated % of waste deducted from total available Link to comment Share on other sites More sharing options...
-Queue- Posted April 18, 2006 Share Posted April 18, 2006 I might suggest using a one-record table to hold the current percentage value. Then have a field in the stock table which auto-enters this value and use this field for your final calculation. You can change an existing record's value if necessary; otherwise, changing the 'default' value in the one-record table will only effect records created afterward. Link to comment Share on other sites More sharing options...
bmen Posted April 18, 2006 Author Share Posted April 18, 2006 OK Many thanks for your help Ill go with the one record option as im not concerned about previous level the incoming stock varies on a daily basis and im only concerned with what is in at any current time jacky p.s it will be tomorrow before i attempt this and ill let you know how i get on Link to comment Share on other sites More sharing options...
bmen Posted April 19, 2006 Author Share Posted April 19, 2006 hello, just to let you know i tried the addional field set up and it gives me what I need thanks jacky Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6582 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now