How to built a difference directly in the table....?

[#1]

Hi all,

How to built a difference in the table, using expressions, avoiding the script?

Example: I have 2 independ excel - sheets with fields like "Reporting date" - 1.1.2009 and 1.2.2009 , "item "- A , "sum" - the sum for item A on 1.1.2009 "reporting date" was 30, on the 1.2.2009 it was 50.

I need to create the difference between this 50 an 30, directly in the table,just using expressions not in script! How to do that?

Many thanks for any help.

Marta

[#2]

Hi Marta,

I've attached a very basic example of what you could do to get the difference between dates.

You can tweak it to suit your needs.

Thanks

[#3]

Hi Xena,

unfortunately I can´t open your file.

But I solve my problem, thanks your suggestion by =sum( Qty ) - before ( sum( Qty ))

and it works 🙂

But I have one more question - is it possible to built now the sum from this difference? something like =sum(sum( Qty ) - before ( sum( Qty )) )

but it seems to be the wrong formula. The point is, I need to know the sum of the difference for whole year..In the script it´s easy - you can use the left join, for example. But in Diagramm? As dimenssion?

Anybody help?

Thanks a lot,

Marta