simple mathematical expressions

Question

simple mathematical expressions

HJC36

Newbie

Points: 3
More actions
August 17, 2010 at 8:22 am

#225961

Hi,
I am new to SSRS and trying to do (what i would have thought was a pretty simple) mathematical expression in SSRS. Basically i have
=Fields!IC_QUANTITY.Value-sum(Fields!INPUT_QTY_STD.Value)
i then want to add on a
-SUM(Fields!INPUT_QTY_ACTUAL)
To me, the whole thing should resemble something like:
=(Fields!IC_QUANTITY.Value-sum(Fields!INPUT_QTY_STD.Value))-Sum(fields!INPUT_QTY_ACTUAL)
but i just keep getting 'ERROR#', I have played around with the brackets but it doesn't seem to make a difference.
Please help!

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Ray K SSC-Dedicated Points: 31166 More actions · Answer 1

Can you provide some sample data -- what you're working with, and how you want it to look?

+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/

HJC36 Newbie Points: 3 More actions · Answer 2

I have three different sets of data:

A) = Total Qty on Hand (IC_QUANTITY)

B) = Sum of demand for that inventory (sum(Fields!INPUT_QTY_STD.Value))

C) = sum of the amount of that inventory that has been made (sum(Fields!INPUT_QTY_ACTUAL))

I currently have a column that gives me demand for a particular item;

=Fields!IC_QUANTITY.Value-sum(Fields!INPUT_QTY_STD.Value)

where IC_QUANTITY = quantity on hand and INPUT_QTY_STD is the summed demand for that quantity (we have multiple jobs that require the same item to be made)

I want to take away the sum(Fields!INPUT_QTY_ACTUAL) from the current demand statement that i have above to give me more of a realistic demand qty.

I know that the IC_QUANTITY should increase and therefore demand decrease (making everything i am trying to do here redundant) but i think a timing issue is preventing this. I am looking for a different table to pull an on hand quantity from.

Thanks

Ray K SSC-Dedicated Points: 31166 More actions · Answer 3

HJC36 (8/17/2010)
I have three different sets of data:
A) = Total Qty on Hand (IC_QUANTITY)
B) = Sum of demand for that inventory (sum(Fields!INPUT_QTY_STD.Value))
C) = sum of the amount of that inventory that has been made (sum(Fields!INPUT_QTY_ACTUAL))
I currently have a column that gives me demand for a particular item;
=Fields!IC_QUANTITY.Value-sum(Fields!INPUT_QTY_STD.Value)
where IC_QUANTITY = quantity on hand and INPUT_QTY_STD is the summed demand for that quantity (we have multiple jobs that require the same item to be made)
I want to take away the sum(Fields!INPUT_QTY_ACTUAL) from the current demand statement that i have above to give me more of a realistic demand qty.
I know that the IC_QUANTITY should increase and therefore demand decrease (making everything i am trying to do here redundant) but i think a timing issue is preventing this. I am looking for a different table to pull an on hand quantity from.
Thanks

This doesn't answer my question. What I'm looking for is something like this:

[Table A]

Inventory Qty

Beans 10

Carrots 25

Corn 14

[Table B]

Inventory Qty

Beans 25

Carrots 13

Corn 10

[Output]

Inventory Table A Table B Sum

Beans 10 25 35

Carrots 25 13 38

Corn 14 10 24

Long story short: don't make us have to work to figure out what you want. If you can help us visualize what you want, we can help you a lot better.

A lot of us (myself included) are actually at work, and don't have time to decrypt what you're trying to ask. Otherwise, we're just guessing as to what you want. The easier you make it for us to help you, the better we can help you.

Apologies if I sound curt; I just want to make sure you get the help you need.

+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/

Ray K SSC-Dedicated Points: 31166 More actions · Answer 4

Ack . . . I just read you were asking about SSRS. For some reason, I was thinking SSMS.

Sorry. My bad. :blush:

+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/