how to get a previous value in a text object

[Anonymous]

Hi,

I have a field D which has values 1 to 20

Now i created a Text object in that if i select an value 7.The previous value of 7 i.e., 6 want to appear on the text object please clarify my doubt.

Thanks in advance.

[bbi_mba_76]

Hi,

I don't understand so much, with =D-1 you could get the result, but I think I'm missing somethings

[jonathandienst · Accepted solution]

Hi

If the numbers are sequential, then in a text box

=Value - 1

If they are not, then

=Max({<Value = {"<$(=Max(Value))"}>} Value)

Regards

Jonathan

[Anonymous]

Hi,

Yes You are correct exactly my requirement is I have an field D

example :

D

1

2

3

4

5

6

7

If i click any number from 1 to 7 I want get sum of all above numbers.

for example : If I select 4 i want get sum of all above numbers of 4 i.e.,1+2+3=6

in a text object.

[sujeetsingh]

Hello see the sample .

I have done it from script

[rustyfishbones]

Yes BBI_MBA_76 is correct

=D-1 shoud give you the answer

[Anonymous]

Hi,

Yes You people were correct exactly my requirement is I have an field D

example :

D

1

2

3

4

5

6

7

If i click any number from 1 to 7 I want get sum of all above numbers.

for example : If I select 4 i want get sum of all above numbers of 4 i.e.,1+2+3=6

in a text object.

[bbi_mba_76]

=Sum({<D = {"<$(=Max(D))"}>} D)

[Anonymous]

Thank you very much for your reply

another doubt

if we want this answer in table view with D as dimension the same expression will work or we want to make any changes for that..?

[bbi_mba_76]

With a chart you could use the full accumulation