Straight Table Issue

[azmeerrehan]

Attached please find the output in a straight table. I would like columns C and D to appear in one line and Column E should be the difference (-47285). Below is the expression I amusing for Column E.  available_qty and sum_orders are coming from 2 different data sets. I think there is a way to do it using Aggr . Also please note 2 different dates for both expressions

Please help

sum({<Date = {"$(vMax_Prod_Prod_Date)"}>}  available_qty)

-

sum({<Date = {"$(vMax_Prod_Order_Date)"}>}  sum_orders)

[sunny_talwar]

May be this

If(Len(Trim(D)) > 0,

Sum(TOTAL <A, B, C> {<Date = {"$(vMax_Prod_Prod_Date)"}>}  available_qty)

-

Sum(TOTAL <A, B, C> {<Date = {"$(vMax_Prod_Order_Date)"}>}  sum_orders))

[azmeerrehan]

Ur expression is excluding a row. I dont want to exclude the row but show them in a single row with the difference shown in column D

[azmeerrehan]

Sorry difference shown in column E

[sunny_talwar]

Excluding a row? Not sure I understand

[azmeerrehan]

If u look at the output.png I attached i have 2 rows   and the net in column E should be -47825 . Ur expression is simply excluding the -52626

[sunny_talwar]

I wouldn't think it should... but I don't see what you see . Unless you are able to share something else, I will let some one else try to help.

Best,

Sunny

[azmeerrehan]

Attached please find the sample qvw and XLS. I would like both rows to be displayed as a single row showing the difference

[azmeerrehan]

Just uploaded a sample qvw and sample xls

[sunny_talwar]

For the sample where NAME2 is '-' and not null... try this

=If(NAME2 <> '-', Sum(TOTAL <NO, CODE, NAME1> SUM))