Newbie Questions

Re: Recalculate lot price selection after changes in table

FlameKurosei — Thu, 24 Aug 2017 21:12:20 GMT

Hello again Hilary,

May I ask what you changed to make this modification work? I'm a little lost on trying to recreate it.

Thank you,

Flame

Re: Recalculate lot price selection after changes in table

FlameKurosei — Thu, 24 Aug 2017 19:21:17 GMT

Edit: Hmm, I must be doing something wrong with your modification. It's still showing me the first row duplicated.

However, it will show the correct pricing if I only fill in one of the pages (either the Raw Material or the Routing pages).

Edit 2: Never mind! I set something as a textbox instead of a calculated value by mistake. I think that's where the issue is, since it works now.

Re: Recalculate lot price selection after changes in table

Hilary Stoupa — Wed, 23 Aug 2017 23:58:48 GMT

Try this one.

Re: Recalculate lot price selection after changes in table

FlameKurosei — Wed, 23 Aug 2017 20:16:33 GMT

Hi again Hilary,

I'm stuck again trying to get the "Overall Cost Per Piece" field to work on bottom of the first page (the Customer Information view). I added a "current()" to the formula and it still continues to display the first row duplicated downward.

EDIT: For clarification, the field should be the sum of both the "CostPerPieceRAW" and "CostPerPieceR", divided by two when the two fields are equal in customer quantity.

For example:

Routing Totals =

[100=$3.00]
[200=$1.00]

Raw Material Totals =

[100=$5.00]
[200=$2.50]

Then Customer Information Totals =

[100=$8.00]
[200=$3.50]

I'm assuming I'm missing a preceding-sibling or following-sibling to the formula...? It seems awfully simple.

(Thank you again in advance.)

Re: Recalculate lot price selection after changes in table

Hilary Stoupa — Wed, 23 Aug 2017 19:13:07 GMT

Wonderful, glad it is doing what you need it to. :)

Re: Recalculate lot price selection after changes in table

FlameKurosei — Wed, 23 Aug 2017 18:29:41 GMT

Hello Hilary,

I just tried what you sent to me, and I've adjusted it so that it calculates the entire page correctly. It works now!

Thank you so much for the help again.

Re: Recalculate lot price selection after changes in table

FlameKurosei — Wed, 23 Aug 2017 00:52:52 GMT

Hi Hilary,

Thank you for the help so far--I'll give this a shot tomorrow when I get to the office.

The "100" from Op 10 comes from not having a "customer qty" field for the Manufactured part, I think, so it just defaults to showing the first row/first quantity? It's very odd. I added a table for customer quantities in Manufactured Part too, just in case that was the issue.

Re: Recalculate lot price selection after changes in table

Hilary Stoupa — Tue, 22 Aug 2017 23:10:37 GMT

I think I at least have the table rows hiding correctly for your scenario, and added a calculated value that I think summarizes your "Outside Services" correctly. I don't understand how "Op. 10" above is associated with the Customer Qty of 100? And I'm not really sure how to relate this data. But hopefully this will point you in the right direction.

Re: Recalculate lot price selection after changes in table

FlameKurosei — Tue, 22 Aug 2017 03:16:19 GMT

It's okay, let me explain the steps towards getting the issue--I don't have the form right in front of me, so here's a scenario that relates to my previous screenshot:

On the "Customer Information" page, I type in the desired quantities of 100 and 200.
On the "Routing" page, I fill in, say, three operations (the op # counter goes by 10s).

- Op. 10: Manufactured Part. I fill out the table until I have a subtotal.
- Op. 20: Outside Service. I fill out the lot table, click until both quantities (100 and 200) are shown on the "customer qty" field, and then I have a subtotal.
- Op. 30: Outside Service. Again, I fill out the lot table, click until both quantities (100 and 200) are on the "customer qty" field, and then I have a subtotal.

Now, on the bottom right table that's supposed to total the values based on quantity, it instead separates the quantities based on the operation number. This is the small screenshot I posted earlier (please see the previous post with the screenshot in question for a visual aid):

[100=$1.00] (belongs to Op. 10)
[100=$5.00] (belongs to Op. 20)
[200=$1.00] (belongs to Op. 20)
[100=$6.00] (belongs to Op. 30)
[200=$5.00] (belongs to Op. 30)

The problem is, I want to just show the respective quantities totaled/summed together. Thus, I would like the bottom right table to show this:

[100=$12.00] (which is $1+$5+$6=$12)
[200=$6.00] (which is $1+$5=$6)

Lastly, once this is fixed, I would like to "total the totals" on the Raw Material and Routing page, and have that value on the Customer Information page. Thus, on the Customer Information page, it would have something like this:

[100=(Total Raw's Price for 100+ Total Routing's Price for 100)]

[200=(Total Raw's Price for 200+ Total Routing's Price for 200)]

Does this make sense? Is this possible? I'm not sure how to change it so that it works. Any advice would be helpful.

Thank you again in advance.

Re: Recalculate lot price selection after changes in table

Hilary Stoupa — Mon, 21 Aug 2017 23:12:29 GMT

I'm sorry, I need more screenshots or something - I don't understand the issue. Is it that you've added multiple instances of RoutingTableRepeat and then you get the data as displayed above in the grey table?

Re: Recalculate lot price selection after changes in table

FlameKurosei — Mon, 21 Aug 2017 17:28:43 GMT

Hello Hilary!

Yes if you could please. I tried some other methods but it doesn't seem to work.

Re: Recalculate lot price selection after changes in table

Hilary Stoupa — Mon, 21 Aug 2017 15:35:05 GMT

I was out last week - still need help with this?

Re: Recalculate lot price selection after changes in table

FlameKurosei — Tue, 15 Aug 2017 15:35:54 GMT

Hello again Hilary,

I'm having trouble implementing the carried over quantities solution you showed me, specifically for the "Routing" view of my form. Due to the operation counter, it appears to show duplicate quantities, separated by "Op. #" (essentially the step counter in this view). I would like it to display each quantity only once for the totals on the bottom right. How exactly should I approach this? I tried using hides for duplicate quantities, but that just hides the values without adding them into the total cost per piece.

I have attached a picture of the error in preview, and the updated form.

Thank for the help in advance.

Re: Recalculate lot price selection after changes in table

Hilary Stoupa — Fri, 11 Aug 2017 17:51:17 GMT

Happy to help & glad that will work for you. :)

Re: Recalculate lot price selection after changes in table

FlameKurosei — Fri, 11 Aug 2017 17:43:27 GMT

Hilary Stoupa:
See attached for what I mean - preview and in the second table (RAW view) you'll see the qty is set for as many rows as you enter in the table in view one.

Oh wow! Yes, this can work--I'll have a little dialogue box to tell the person to click until all the quantities are displayed on the RAW and ROUTING pages.

Thank you so much Hilary for helping me out. (:

~Flame