PartWhse.onhandqty BAQ Cal Field

Yahoo Archive
1
Thank you guys. i will def include as much parenthesis as possible going forward. thanks a lot!!!!!

Jose

--- In vantage@yahoogroups.com, Steven Gotschall <sgotschall@...> wrote:
>
> When I create a calculated field, I find its best to go crazy with the parentheses. Also, I think you need an else statement, so try this:
> ÂÂ
> total((if (partwhse.warehousecode = 'XX') then (partwhse.onhandqty) ELSE (0)))
> ÂÂ
>
>
> ________________________________
> From: neverunmacron <neverunmacron@...>
> To: vantage@yahoogroups.com
> Sent: Thursday, March 21, 2013 3:17 PM
> Subject: [Vantage] PartWhse.onhandqty BAQ Cal Field
>
> ÂÂ
> hello
> i am trying to create a column that shows me the total onhandqty for one of my warehouses. I currently have one column with as a calculate field because the partwarehouse is a summarized table.
>
> In my column where i show all onhandqty the formula is Total(Partwhse.onhandqty)
>
> i have tried total(if partwhse.warehousecode = 'XX' then partwhse.onhandqty) and got a syntax error. i also tried total(find partwhse.onhandqty where partwhse.warehousecode = 'XX' and i keep getting syntax error.
>
> any help?
>
>
>
>
> [Non-text portions of this message have been removed]
>
2
hello
i am trying to create a column that shows me the total onhandqty for one of my warehouses. I currently have one column with as a calculate field because the partwarehouse is a summarized table.

In my column where i show all onhandqty the formula is Total(Partwhse.onhandqty)

i have tried total(if partwhse.warehousecode = 'XX' then partwhse.onhandqty) and got a syntax error. i also tried total(find partwhse.onhandqty where partwhse.warehousecode = 'XX' and i keep getting syntax error.

any help?
3
Good Day Neverunmacron:



See below.




Len



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of neverunmacron
Sent: Thursday, March 21, 2013 3:18 PM
To: vantage@yahoogroups.com
Subject: [Vantage] PartWhse.onhandqty BAQ Cal Field





hello
i am trying to create a column that shows me the total onhandqty for one
of my warehouses. I currently have one column with as a calculate field
because the partwarehouse is a summarized table.

In my column where i show all onhandqty the formula is
Total(Partwhse.onhandqty)

i have tried total(if partwhse.warehousecode = 'XX' then
partwhse.onhandqty Else 0) and got a syntax error. i also tried
total(find partwhse.onhandqty where partwhse.warehousecode = 'XX' and i
keep getting syntax error.

any help?





This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.


[Non-text portions of this message have been removed]
4
When I create a calculated field, I find its best to go crazy with the parentheses. Also, I think you need an else statement, so try this:
Â
total((if (partwhse.warehousecode = 'XX') then (partwhse.onhandqty) ELSE (0)))
Â


________________________________
From: neverunmacron <neverunmacron@...>
To: vantage@yahoogroups.com
Sent: Thursday, March 21, 2013 3:17 PM
Subject: [Vantage] PartWhse.onhandqty BAQ Cal Field

Â
hello
i am trying to create a column that shows me the total onhandqty for one of my warehouses. I currently have one column with as a calculate field because the partwarehouse is a summarized table.

In my column where i show all onhandqty the formula is Total(Partwhse.onhandqty)

i have tried total(if partwhse.warehousecode = 'XX' then partwhse.onhandqty) and got a syntax error. i also tried total(find partwhse.onhandqty where partwhse.warehousecode = 'XX' and i keep getting syntax error.

any help?




[Non-text portions of this message have been removed]