BAQ - Summary Table - Conditional Total

Hi,
I have just started with summary tables...I find that I had a calculated condition that I just put Total(calculated condition if statement, else) and it seems to work.

--- In vantage@yahoogroups.com, "Rashid Mahmood" <emailrashidforum@...> wrote:
>
> I need to create a BAQ for all the manufactured parts onhandqty in two coloums, onhand qty for all onsite warehouse and onhandqty for all external warehouses against each part.
>
> I am using the part and part bin table with outher join, part bin table is summarised to get only one line per part, but I am getting an error message when trying to do the conditional total (total partbin.onhandqty where partbin.warehousecode = "100" or partbin.warehousecode = "300").
>
> I have also tried to use the if statement (If partbin.wareshousecode = "100 or partbin.warehousecode = "300" then Total(partbin.onhandqty)) but no success.
>
> so my question is that is it possible to do the conditional calculation on the summarised table?
>
> Thanks in advance for your help.
>
> Regards,
> Rashid Mahmood
>
1 Like
I need to create a BAQ for all the manufactured parts onhandqty in two coloums, onhand qty for all onsite warehouse and onhandqty for all external warehouses against each part.

I am using the part and part bin table with outher join, part bin table is summarised to get only one line per part, but I am getting an error message when trying to do the conditional total (total partbin.onhandqty where partbin.warehousecode = "100" or partbin.warehousecode = "300").

I have also tried to use the if statement (If partbin.wareshousecode = "100 or partbin.warehousecode = "300" then Total(partbin.onhandqty)) but no success.

so my question is that is it possible to do the conditional calculation on the summarised table?

Thanks in advance for your help.

Regards,
Rashid Mahmood