withSum() having issue when field have html tags, no other option to add custom header footer column, like withLabel etc

[alzen8vtg]

Livewire PowerGrid version

v6.2.2

Livewire version

v3.6.1

Laravel version

v12.1.1

Which PHP version are you using?

PHP 8.4

Which Theme are you using?

Tailwind

Have you published the resource files and customized them? (php artisan vendor:publish)

Yes

What is the problem?

what i plan to achieve is an additional row with specific column to get the summary and some other column just show label

what i can achieve (or hack) is looks like this

Problem:

1. unable to summarize my field if at fields method are added with html tags or style with colors:
   poc, when income is pure value, it return properly, when i add htmls it stop working as shown in picture above

->add('income2', function ($entry) {
                $color = -$entry->income< 0 ? 'text-red-500' : 'text-green-500';
                return "<span class=' {$color}'>" . number_format(-$entry->income, 2) . "</span>";
            })

2. i want a summary value without label, now i could put empty string but it will return with ":" as shown in picture above

     Column::make('Income', 'Income')->bodyAttribute('text-right slashed-zero tabular-nums')
                ->headerAttribute('normal-case')->sortable()->hidden(isHidden: false, isForceHidden: false)
                ->withSum(
                    label: '',
                    header: false,
                    footer: true),

            Column::make('Income2', 'Income2')->bodyAttribute('text-right slashed-zero tabular-nums')
            ->headerAttribute('normal-case')->sortable()->hidden(isHidden: false, isForceHidden: false)->withSum(
                label: '',
                header: false,
                footer: true),

3. want to add only label to particular column, like i want to add "Grand total" underneath No. column i only can hack it with summarizeFormat method as shown below, also it shows ":Grand Total" instead of "Grand Total":

    public function summarizeFormat(): array
    {
        return [
            'no.{sum}' => function ($value) {
                return  'Grand Total';
            },
          ...

Suggestion:

1. no idea what to suggest, maybe some method to add color to negative and positive value?

2. to hide colon maybe add this for someone who only wants to show Value of that summary
   ->withSum(
   label: '',
   header: false,
   footer: true
   showLabel: false),

3. maybe give more withXXXX() to be added, instead of withCount withSum etc but without any option just want to show label at footer like Grand Total label for that last row at "No." column, also make this withXXX() with no colon":" shown.

->withEmptyLabel(
label: 'Grand Total',
header: false,
footer: true
)

what ends up i want to achieve is this:

Code snippets

public function summarizeFormat(): array
{
    return [
        'no.{sum}' => function ($value) {
            return  'Grand Total';
        },
        
        'income.{sum}'       => fn($value) => number_format($value, 2),
        'income2.{sum}'       => fn($value) => number_format($value, 2),
   ];
}

    public function fields(): PowerGridFields
{
    return PowerGrid::fields()
        ->add('no', function ($entry, $index) {
            $perPage = $this->perPage ?? 10; // ✅ Default to 10 if not set
            $currentPage = request()->query('page', 1);
            return ($currentPage - 1) * $perPage + $index + 1; // ✅ Continuous row numbers
        })
        ->add('tranId', fn ($query) => sprintf(
            '<a target="_blank"
                class="underline text-blue-600 hover:text-blue-800 visited:text-purple-600"
                href="%s">%s</a>',
            route('wallet.trans.detail', ['id' => $query->tranId]),  // Generate route URL
            e($query->tranId) // Escape to prevent XSS
        ))
        
        ->add('tranDate', fn ($model) => Carbon::parse($model->tranDate)->format('d/m/Y H:i:s'))
        ->add('income', function ($entry) {
            return -$entry->income;
        })
        ->add('income2', function ($entry) {
            $color = -$entry->income< 0 ? 'text-red-500' : 'text-green-500';
            return "<span class=' {$color}'>" . number_format(-$entry->income, 2) . "</span>";
        })
        
        ->add('Balance', fn ($entry) => number_format($entry->balance, 2));
        }
        
        
            public function columns(): array
{
    return [
        Column::make('No.', 'no') ->withSum(
            label: '',
            header: false,
            footer: true)->sortable()->hidden(isHidden: false, isForceHidden: false)->bodyAttribute('text-right slashed-zero tabular-nums')
        ->headerAttribute('normal-case')->sortable(false),

        Column::make('Tran ID', 'tranId')->bodyAttribute('text-right slashed-zero tabular-nums')
        ->headerAttribute('normal-case')->sortable()->hidden(isHidden: false, isForceHidden: false),

        Column::make('Tran Date', 'tranDate')->bodyAttribute('text-right slashed-zero tabular-nums')
            ->headerAttribute('normal-case')->sortable()->hidden(isHidden: false, isForceHidden: false),

            Column::make('Income', 'Income')->bodyAttribute('text-right slashed-zero tabular-nums')
            ->headerAttribute('normal-case')->sortable()->hidden(isHidden: false, isForceHidden: false)
            ->withSum(
                label: '',
                header: false,
                footer: true),

        Column::make('Income2', 'Income2')->bodyAttribute('text-right slashed-zero tabular-nums')
        ->headerAttribute('normal-case')->sortable()->hidden(isHidden: false, isForceHidden: false)->withSum(
            label: '',
            header: false,
            footer: true),

        Column::make('Balance', 'balance')->bodyAttribute('text-right slashed-zero tabular-nums')
            ->headerAttribute('normal-case')->sortable()->hidden(isHidden: false, isForceHidden: false),
            ]
            }

How do you expect it to work?

Suggestion:

1. no idea what to suggest, maybe some method to add color to negative and positive value?

2. to hide colon maybe add this for someone who only wants to show Value of that summary
   ->withSum(
   label: '',
   header: false,
   footer: true
   showLabel: false),

3. maybe give more withXXXX() to be added, instead of withCount withSum etc but without any option just want to show label at footer like Grand Total label for that last row at "No." column, also make this withXXX() with no colon":" shown.

->withEmptyLabel(
label: 'Grand Total',
header: false,
footer: true
)

what ends up i want to achieve is this:

Please confirm (incomplete submissions will not be addressed)

• I have provided easy and step-by-step instructions to reproduce the bug.
• I have provided code samples as text and NOT images.
• I understand my bug report will be removed if I haven't met the criteria above.