Calculate accumulated values

[Anonymous]

Hello,

in a table accumulated values should be calculated. The column Proj contains accumulated values. How can column Test calculated?

The following formula have no function (Column (1)-Column (2))

Regards Stefan

[sunny_talwar]

May be this

Column(1)-RangeSum(Above(Proj, 0, RowNo()))

[Kushal_Chawda]

Use this

sum(Prod)-sum(Proj)

[sunny_talwar · Accepted solution]

Or change your second expression to be this

RangeSum(Above(Proj, 0, RowNo()))

with no accumulation selected

[Anonymous]

Many thank. How can I create a 100% stacked bar chart?

[sunny_talwar]

What is the logic? Can you share the expected percentage in Excel file?