Please any help with formula.

[alanfallow1958]

I have been jumping from data source to data source so now after being put off excel I have went to sharepoint.  I have a basic ledger with 100 records.  I also have a Trial Balance which works fine with excel but with MSlists I get an exclamation and error.  This is the formula.                       TEXT =      "£" & Sum(Filter(Mainledger, Account = "Campsout"),Debit)

Any help would be just great.

[Jeff_Thorpe]

You are probably getting a delegation warning because the Sum() isn't delegable by SharePoint. If your SharePoint list is below the delegation limit in your app settings then you will be fine. By default the data row limit (delegation) is 500 and you can increase to 2000.

There are some data sources like Dataverse and SQL where the Sum() is delegable.

[alanfallow1958]

Hi Jeff thanks for reply.

Not quite sure what that means but.  I am getting exclamation mark but no figures show for the calc.  The sharepoint only has about 150 records prob only another 50 at the most.  How do I sort the sum delegable whatever that is?🤔😁  All works ok on excell but was recommended to stay clear of that..

Thank you again.

[v-xiaochen-msft]

Hi @alanfallow1958 ,

It worked for me. Please share the screenshots for troubleshooting.

Best Regards,

Wearsky

[alanfallow1958]

Good morning thanks for getting back.  Have attached screen images.  The Trial Balance is just a screen with text boxes and the calculations it gets from Mainledger a Sharepoint list.  I dont have any output on image 3 from the calculations.  Can share app if needed.  Thanks very much.

[alanfallow1958]

Another image with error

[alanfallow1958]

The accounts column is a choice field does that matter.

[Jeff_Thorpe · Accepted solution]

If Account is a choice column then try using Account.Value instead of Account.

[alanfallow1958]

Ok will try and get back.  Thank you.

[alanfallow1958 · Accepted solution]

Jeff

You are a genious that worked thanks very much.

Watched a video on delegate by Shane somebody.  Still not a clue.😁

Thank you