yeah I did try that, my problem was in my linking. Even with outer joins/inner joins and trying a couple different setups I was not able to get the information to display in a fashion that would allow for blanks. Basically it would show ever po date for every SO date. But before I could get too far on this we have decided to change our approach on this. Thank you for your response though.
--- In vantage@yahoogroups.com, Karen Schoenung <kschoenung@...> wrote:
>
> So, you tried CalcDate ...If OrderHed.ReqDate <> "" then OrderHed.ReqDate else POHead.DueDate? Then in the baq sort by CalcDate? What is happening that is wrong?
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of jarradlayne
> Sent: Tuesday, June 18, 2013 3:35 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Sorting a BAQ/Dashboard by two fields in one column?
>
>
>
> Hello Group,
>
> Is it possible to sort a BAQ or a dashboard grid by two fields in ascending order in the same column? For this case it would be dates. For example Sales Order Required By Dates and PO Due Dates. I want one column to display either the SO Req Date or PO Due Date and want these dates to appear in ascending order. Is this possible? I imagine you could possibly create some type of calculated field to achieve this, but I've had no luck. What I'm trying to achieve is a supply and demand running total where all the future orders and PO's for a part are listed in chronological order with the order/PO qty subtracting/adding to the current on hand qty.
>
> Thanks,
> Jarrad
>
>
>
> [Non-text portions of this message have been removed]
>