Evaluate the progression of a data

[#1]

Hi,

I have a little problem.

I have a table with 3 column. A project, a date and a data associate. For example :

Project	Date	Data
Project 1	01/01/2011	10
Project 1	01/02/2011	12
Project 2	01/01/2011	20
Project 2	01/02/2011	15
Project 2	01/03/2011	10

And I want to evaluate the progression like that :

Project	Date	Data
Project 1	01/01/2011	10
Project 1	01/02/2011	12
Project 2	01/01/2011	20
Project 2	01/02/2011	15
Project 2	01/03/2011	10

I know where I can change that but I don't know which expression I have to write.

Thanks a lot,

Annie

[pat_agen]

hi,

if you are in a straight table and Project and Date are dmensions and your expression is sum(Data) thne you can achieve what you wnat by using this expression in the Text Color attribute field:

if(len(above(Data))>0,

if((Data>above(Data)),green(),red()))

hope this helps

[#3]

First thank you for your answer.

But I have the french version and I don't know where I have to write this expression...

[pat_agen · Accepted solution]

(re) bonjour Annie,

[dear all, just practisng some French here. I am trying to explain how to enter the properties for Text color]

ce n'est pas ce qui était écrit dans ton premier message ;-).

je n'ai pas la version française mais suis ces clicks et ça devrait marcher:

clicker sur le tableau, clicke de droite pour ouvrir "properties", aller sur l'onglet "expressions( là où l'on écrit sum(Data).

clicke sur la petite croix qui se trouve à gauche de l'expression et tu verras la liste des attributs. La deuxième s'appelle en anglais "Text Color", clicke dessus et tu rentre l'expression ici.

voir image

hope this helps.

[#5]

That's great !!! Thank you and by the way, good french