This was very simple in Alpha4; should be just as simple in A5v4 build266. It's not a walk in the sun, since I've been at it for what seems ages. This is a situation that pleads for example as in the other discussion group. Situation is simple; solution should be too.
Problem: I have a field for weekly average. However, I can't results to it. Have built two functions so far. A calc field rule seems too inadequate. Let's assume I'm tracking a weekly stock average. I want to keep a running total of the average on a daily basis. Some days, of course, the market is closed. I have a field in which to enter the market on a daily basis, and the calc field for the average - which I cannot get the result in to. After averaging, I round to the quarter point. A function does this. (Round to $x.xxxx). So far I have another function that also computes the divisor, i.e., number of days the market is open, on a running basis.
Should be as easy as falling off a log. Add the data for each day of the week; divide by the appropriate number of days, round, and place the result in the calculated field.
This may be the wrong approach; however my intent was to build another function to add the data, and include the divisor and round functions I've created.
I can't even get the third function built. This is my tale.
1. I select the appropriate table in "Tables/Sets."
2. I click on the "Code" tab.
3. Select "New".
4. Select Function.
5. It presents a screen with "Create Global Function".
Underneath is another window that is the Code Editor with my Round Function. (Why?)
6. I rename the Function in the "Create Global Screen"; fill in three names (Assume three different stocks). Click on the Disk icon to save. If in fact it saves, it must go to the electronic Valhalla, for I can not find it again.
I've repeated this action a number of times, yet it's nowhere to be found, and does not take me to a screen to enter code. The "OK" gets me to the underlying screen, which is my Round Function.
Since I've already created two functions, why can't I create another?
In other discussions, there is talk of examples. Certainly this begs for example. It also might help to answer the other questions asked on how|when|why to use X-Basic, and how to relate it to Field Rules -> Calc.
I've tried expressions in the calc field, but they too disappear.
Thanks to one and all who can get me out of the maze. I believe a well done example might benefit a number of lost souls.
Problem: I have a field for weekly average. However, I can't results to it. Have built two functions so far. A calc field rule seems too inadequate. Let's assume I'm tracking a weekly stock average. I want to keep a running total of the average on a daily basis. Some days, of course, the market is closed. I have a field in which to enter the market on a daily basis, and the calc field for the average - which I cannot get the result in to. After averaging, I round to the quarter point. A function does this. (Round to $x.xxxx). So far I have another function that also computes the divisor, i.e., number of days the market is open, on a running basis.
Should be as easy as falling off a log. Add the data for each day of the week; divide by the appropriate number of days, round, and place the result in the calculated field.
This may be the wrong approach; however my intent was to build another function to add the data, and include the divisor and round functions I've created.
I can't even get the third function built. This is my tale.
1. I select the appropriate table in "Tables/Sets."
2. I click on the "Code" tab.
3. Select "New".
4. Select Function.
5. It presents a screen with "Create Global Function".
Underneath is another window that is the Code Editor with my Round Function. (Why?)
6. I rename the Function in the "Create Global Screen"; fill in three names (Assume three different stocks). Click on the Disk icon to save. If in fact it saves, it must go to the electronic Valhalla, for I can not find it again.
I've repeated this action a number of times, yet it's nowhere to be found, and does not take me to a screen to enter code. The "OK" gets me to the underlying screen, which is my Round Function.
Since I've already created two functions, why can't I create another?
In other discussions, there is talk of examples. Certainly this begs for example. It also might help to answer the other questions asked on how|when|why to use X-Basic, and how to relate it to Field Rules -> Calc.
I've tried expressions in the calc field, but they too disappear.
Thanks to one and all who can get me out of the maze. I believe a well done example might benefit a number of lost souls.
Comment