Jump to content
• 0

Trouble subtracting columns in worksheet

Question

How do I get one column to subtract the summarized count from another column? I can see what is going on, and why I am getting the results I am getting, but not sure how to get Column E to be correct. It is not subtracting the summarized values of D, but each individual item.

Recommended Posts

• 0

What is the formula in Column C?

Link to comment
• 0

='Exhibit Element'.'Quantity–Total Stock'

I created a Field in the Record format for  what we have as our total stock of these items.

Link to comment
• 0

I am also wondering why, when I try to format the thumbnails to justify to the left, I get this:

Link to comment
• 0

Can't answer your justify question, but the formula should read:

='Exhibit Element'.'Quantity'-'Exhibit Element'.'Total Stock'

Link to comment
• 0

I inserted that formula and it failed.

Link to comment
• 0

Are the Quantity and Total Stock record fields set to number?  I did a quick test on my end with a basic 2 field record and was able to get it to work as expected.  Can you post a picture of the record Edit Record Format window for the attached record?

Link to comment
• 0

Screenshot of my test showing working formula.

Edited by Jesse Cogswell
Link to comment
• 0

It was set to integer. I changed it to number, but it didn't work

Link to comment
• 0

I have to go back through my notes, but the idea of SUMmarized subrows calculating independently and not being able to be used for mathematical calculations is Working as Designed (WAD). I think there was some kind of work around but I can't remember what.

I will find that thread later today and respond again.

Link to comment
• 0

Would something like this work? Maybe not. My attempt (below) failed.

Link to comment
• 0

Here is the thread about this back at the end of 2016. The basic issue is that you can't do math on SUMmarized values. See the note about it being working as designed. I will try and find some time this afternoon to see if I can figure out a work around.

Link to comment
• 0

@Pat Stanford Thank you Pat, but I'm afraid I don't see a link to the thread.

Link to comment
• 0

Let's try this again.

Link to comment
• 0

@Pat Stanford Got it. Well, that's a stinker. Kind of seems lame, to me. It dramatically reduces the value of worksheets form me.

I don't suppose that was changed in 2021? We're scheduled to get it some day (soon, I hope).

Thanks again,

Mark

Link to comment
• 0

Thank you for your help. My problem is not getting columns to subtract each other, but when I SUMmarize subrows and then try to subtract those sums from another cell in a different row. The cells that aren't summarized calculate just fine.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Restore formatting

Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×

• KBASE
• MARIONETTE

×
• Create New...