#value in Listbox or scorecard (Xcelsius)

Dear All,

I am getting the data from BI Query.

Everything is fine till the data.

A1 B1 C1 D1_

SALES DOC NO DATE TODAY DIFFERENCE

101 21/10/2010 08/02/2011 08/02/2011 - 21/10/2010

102 21/08/2010 08/02/2011 08/02/2011 - 21/08/2010

103 21/07/2010 08/02/2011 08/02/2011 - 21/07/2010

The A1 & B1 cells getting the data from BI Query, what i am trying to do is c1 cells i am calling todays date,

I am want to minus the date(B1) with Todays date(C1). Definelty it gives the number, but when i am trying to

call the D1 and A1 cells it throws the #value.

A1 D1

101 #value

102 #value

103 #value

Experts Kindly help me in this regards, where i am going wrong, how to display the difference.

I have also changed the D1 cells format in number.

Regards,

Suman

Edited by: sumanchuman on Feb 8, 2011 10:05 PM