6 Replies Latest reply on Jun 27, 2017 5:22 AM by Richard Cheslo

# Set a Value for Subsequent Calculations via Parameter

I am not seeing the forest for the trees, on what I believe should be a straightforward approach, but perhaps I have stared at too many spreadsheets today, and I just don't get it. I am trying to set up a selectable value via a parameter to use as a denominator in the example below. The logic is just evading me, so I am shouting out for compass out of the woods. Workbook is attached. Thank you!

• ###### 1. Re: Set a Value for Subsequent Calculations via Parameter

Hi

If i understood your question correctly .   I will do calculation like below

SUM([Amount])   /    attr({sum(if [Denominator Choice] = [Service] then [Qty]  end)})

1 of 1 people found this helpful
• ###### 2. Re: Set a Value for Subsequent Calculations via Parameter

It looks like you've got it working in the attachment, if you wrote it a different way then you're still looking for the same result, right ?

This gives the same answer, just another way of writing the same logic:

SUM([Amount])/Attr(IIF([Denominator Choice] = "SHIPPING",{ FIXED [Service]="SHIPPING":SUM([Qty])},{ FIXED [Service]="RECEIVING":SUM([Qty])}

• ###### 3. Re: Set a Value for Subsequent Calculations via Parameter

Thank you Ari. This is exactly what I was aiming for.

• ###### 4. Re: Set a Value for Subsequent Calculations via Parameter

I appreciate your reply, and I will try to sort out the error later today.

• ###### 5. Re: Set a Value for Subsequent Calculations via Parameter

I think, you need a closing parenthesis for ATTR function

• ###### 6. Re: Set a Value for Subsequent Calculations via Parameter

At a glance yes, but simply adding a parenthesis to the end did not work. Maybe it was the copy and paste, but I had to run. Still though I very much appreciate both of your replies.

Best regards,

Richard Cheslo |  Corporate Quality Manager

1373 Enterprise Drive | West Chester, PA 19380

610-793-8316|  215-384-3175

rcheslo@ctdi.com<mailto:rcheslo@ctdi.com> | www.ctdi.com<http://www.ctdi.com/>

Celebrating 40 years of service excellence.

This E-mail and any attachments are confidential and are solely for the use of the intended recipient. If you are not the intended recipient or have received this E-mail in error, please notify the sender and destroy/delete all copies of this message