Substract 2nd and 3rd columns into 4th column

[ngreddy1982]

  I have created a columns using "Concatenate Load * Inline [Elapsed Days];"

  Now I want to subtract how many days between shipment date to  registering date.

  Please help.

[sunny_talwar]

Why concatenate load?

I think all your need to do is this

LOAD [Order Date],

           [Shipment Date],

           [Registering Date],

           [Registering Date] - [Shipment Date] as [Elapsed Days]

FROM .....;

[ngreddy1982]

Hi Sunny,

I have lot of columns next to them, so

[yoganantha321]

Giri,

Date#([shipmentdate], 'MM/DD/YYYY') > 0,Today() - Date#([registeringdate], 'MM/DD/YYYY') as SLA_Aging

I think the above statement will be useful for you

[sunny_talwar]

so...? keeping typing... what is the issue?

[ngreddy1982]

I have report showing with columns order no, order date, ship date , return date , item ,etc ,

now i have to create a column with difference between ship date and return date which is called elapsed days .

[sunny_talwar]

That's exactly what I mentioned here

LOAD [Order Date],

          [Shipment Date],

          [Registering Date],

         [Registering Date] - [Shipment Date] as [Elapsed Days]

FROM .....;

[Anil_Babu_Samineni]

Or may be this? His intention is this? After statement we can load remaining columns also

LOAD [Order Date],

          [Shipment Date],

          [Registering Date],

         [Registering Date] - [Shipment Date] as [Elapsed Days],

          [order no], [ship date] , [return date] , [item]

FROM .....;

[ngreddy1982]

Tried that it is not creating any column or any dimensions to add to chart .

[sunny_talwar]

Would you be able to share the script you have tried?