This topic is 1864 days old. Please don't post here. Open a new topic instead.
I have a calculation that goes like that, I input a number on "Base Imponibile" (say 100), it adds 15% (it gets me 115), it then calculates 4% to the previous result (115) and it gets me 4,60, I then add 2 and the total is 121,60 which is perfect.
And that's the part that works just fine. But I then want to make a reverse calculation, where I input the expected result of Total Calculation and tells me all the other values and here it's where things go awry.
I'm attaching the initial calculation that works as a reference and the reverse calculation which doesn't work as an example. The "2" that gets subtracted in the reverse calculation is a fixed value of a small tax that I have to deduct (imposta di bollo).
I have a feeling that the reverse calculation goes crazy because of some unwanted rounding somewhere, but I am not to sure, so I seek the opinion of more calculation versed persons around.
This should be easy, but my brain just won't cooperate!
I'm moving a bunch of stuff and want to inventory what is in each moving container. I have a very simple parent-child relationship with the parent record having the container number and category of parts/equipment/supplies and the child records describe each piece of equipment in the container. I have a portal with the child records showing for each container, but want to put anatto-entered item number for each piece that has the container number followed by a dash and then followed by a serialized number for each item in that particular container. For example, I would have container 1 labeled "Glassware" and Container 2 labeled "Chemicals". In Container 1's portal I'd like to see:
Item Description Qty
1-1 Beakers, 500ml 4
1-2 Beakers, 250 ml 2
and in Container 2's portal I'd like to see:
Item Description Qty
2-1 Potassium 4 g
2-2 Sodium 26 g
I'd like to auto-fill the item numbers, but can't figure out how to reset the serialization for each parent record.
Any help is greatly appreciated.
Thanks and keep yourselves safe!
I'm using this calculation--in a parent table in a field temporarily named 'Temp'--to grab course numbers from the course_number field in a related/child table:
UniqueValues ( List ( ASSIGNMENT_COURSE::Course_Number__lxt ) )
(I'm using this calc because the child table contains multiple records with the same course number; it's not a key field.)
My intent is to use six buttons--in the parent table--where each button would grab an assigned row's value using the calculation above. For example, say that the above calc has this result:
I want Button 1 to grab AST-100; Button 2 to grab EDU-100; Button 3 to grab EDU-300, etc.
Mind you, I can't make a value list out of Temp because it can't be indexed.
TIA for your help!
Gents, need your help on the following issue:
I need to track my expanses. There are 4 tables: Products, PriceChanges, Transactions.
The problem: I need to make a script which will make calculations in transactions tab, accounting for the latest price change.
01 jan17 I bought one bottle of wine for $1
03 jan 17 I bought the same bottle of wine for $1,5. So the latest price is $1.5
In Products table there is one record which is wine.
In PriceChanges table there are two records: $1 and $1.5
I need that Transactions table automatically take corresponding wine prices while adding new or past records.
Who Viewed the Topic1 member has viewed this topic:Daemon