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.
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
>