Formula question - change week over week

[shannonlp]

HI,

I have a simple report where I am displaying the following:

kpi_curr_dttm
kpi_curr_val

I need create a formula field that will show the change week over week for the kpi_curr_val.

The report currently looks like

Kpi_curr_dttm Kpi_curr_val

10-Sep 78,762,764,312
17-Sep 78,554,364,889
24-Sep 79,140,287,891
1-Oct 79,143,019,604
8-Oct 79,502,788,295
15-Oct 78,443,623,057
22-Oct 77,757,518,326
29-Oct 78,177,750,415
5-Nov 78,161,298,349
12-Nov 76,907,546,759
19-Nov 76,841,592,903

I need it to look like this:

Kpi_curr_dttm Kpi_curr_val Change Week-over-Week
10-Sep 78,762,764,312 --
17-Sep 78,554,364,889 -208,399,423
24-Sep 79,140,287,891 585,923,002
1-Oct 79,143,019,604 2,731,713
8-Oct 79,502,788,295 359,768,691
15-Oct 78,443,623,057 -1,059,165,238
22-Oct 77,757,518,326 -686,104,731
29-Oct 78,177,750,415 420,232,089
5-Nov 78,161,298,349 -16,452,066
12-Nov 76,907,546,759 -1,253,751,590
19-Nov 76,841,592,903 -65,953,856

If anyone could provide some guidance I’d greatly appreciate it.

 

[tkaz]

Have you tried running totals?

 

[shannonlp]

No, I'll take a look.

 

[shannonlp]

When creating a running total field I’m summarizing Kpi_curr_val.

What should I choose for Type of Summary? None of the options seem applicable. I am trying to show the difference between the values for each record.

 

[shannonlp]

No need to responde. Here is the solution:

{Field} - Previous ({Field})