I wonder if anyone can help please.

Each unique ID object has a Total Value against it as an object

The Total Value is then split into Banding in a variable i.e. if Total Value is between 0-1000 Then “£0-£1000” Else 1001-5000 Then "£1001-£5000 etc

Each band attracts a Calculated Percentage in another variable i.e. if Banding = “£0-£1000” Then 0.10 Else if Banding = “£1001-£5000” Then 0.20 etc

Then the calculation in a new variable called Projected is SUM(Total Value*Calculated Percentage)

Example below

**ID**

123

**Total Value**

£100

**Banding**

£0-£1000

**Calculated Percentage**

0.10

**Projected**

£110.00

If i include the Unique ID in the table i can calculate the total Projected figure for all cases, if i delete it and wish to display the total on its own then i get a #Multivalue error even if i wrap a sum around it. I just can work out where i need to apply the change to get this to work. TIA