top of page

How do I change the minimum percentage for identifying month on month credit trends?

Each bank summary shows the month on month trend percentages for total amounts, debits and credits. Months are highlighted in this section if the total monthly credit change exceeds a set percentage. This percentage can be set by changing the named value ‘CreditsMonthlyChangePercentage’ within Excel (Formulas -> Name manager); this should be set between 0 and 100 (e.g. 10% would be set as the value 10). The default value is 30, for 30%.

Recent Posts

See All

Improving Excel with Python (May 2022)

Revisited starter script from January 2021: Split Excel file into separate files Excel is essential, and Python is the future - forcing ourselves to practice the latter by automating some of the commo

Message us or

Call us on +44 (0)20 3287 8283

Mon to Fri: 8am-8pm

Weekends: 10am-6pm

bottom of page