How to sum a currency format?

[ivanfa5]

Hi, I am totally confused about how to sum from a field that contains currency closure.

I already follow some of these documentaries:

1. https://livewire-powergrid.com/table/add-columns.html#currency
2. https://livewire-powergrid.com/table/column-summary.html#withsum
3. https://v2.livewire-powergrid.com/#/table/column-summary?id=column-summary
4. https://v2.livewire-powergrid.com/#/table/add-columns?id=closure-examples

Also, I searched this issue in issues and discovered that it was a bug, and it has been closed. 
#281

But none of those work for me.
My goal is the same as the image shown in the documentary.

The field contains a currency with a sum on the header.

I also try it in powergrid demo, the problem still encounter

The image shown above is of me trying to:

1. Re-format calories field values to a currency, the currency work, but the sum not.
2. Sum 'SALES PRICE' field that has been in a currency by default with step from link number 2 & 3, It doesn't work.

I tried this for calories
->addColumn('calories', function (Dish $dish) { return 'R$ ' . number_format(e($dish->calories), 2, ',', '.'); })
and this
->addColumn('calories', function (Dish $dish) { $fmt = new NumberFormatter('pt_PT', NumberFormatter::CURRENCY); return $fmt->formatCurrency($dish->calories, "EUR"); })
with this in column
Column::add() ->title(__('Calories')) ->field('calories') ->makeInputRange('calories') ->sortable() ->withSum('Sum', true, false),
still not working

or let's try to add currency from the "PRICE" column that has successfully shown the sum but doesn't have currency by default.
->addColumn('price', function (Dish $dish) { $fmat = new NumberFormatter('pt_PT', NumberFormatter::CURRENCY); return $fmat->formatCurrency($dish->price, "EUR"); })
The sum is gone

Could someone please show me or provide the full code for adding currencies with sum?
The documentary didn't help me, and it only showed a piece of code, and the demo also doesn't come with an example like the image shown in links 3 and 4 above. I've been searching for a solution for a couple weeks and have found nothing.
I'm begging for help.
Thanks in advance

[dansysanalyst]

Hi @ivanfa5,

Assuming you have these two columns, price as the raw amount and price_BRL as Brazilian Real currency format.

    public function addColumns(): PowerGridEloquent
    {
        return PowerGrid::eloquent()
            ->addColumn('id')
            
            //1000.00
            ->addColumn('price')
            
            //R$ 1.000,00
            ->addColumn('price_BRL', fn (Dish $dish) =>'R$ ' . number_format(e($dish->price), 2, ',', '.'));
    }

You can then do:

 public function columns(): array
    {
        return [
            Column::add()
                ->title(__('ID'))
                ->field('id', 'dishes.id')
                ->searchable()
                ->sortable(),

            Column::add()
                ->title(__('Price'))
                ->field( 'price_BRL', 'price')
                ->withSum('Total em R$', true, true),

        ];
    }

I will update the doc to make it more clear 😊

[ivanfa5]

Hi @dansysanalyst,

Thank you for your fast response.
Your solution help me and give me more understanding about formatting.
I tried it and it worked, but it leads me to another question.

How do I move the summary into the price field without making a new blank field next to it?

I have tried using your code with removing either 'price_BRL' or 'price' also tried to remove ->addColumn('price') none of those work. The output either shows that the sum gone or it remains in the next column header. 

I also tried to use Column::make instead Column::add, hoping that it'll be a single column. still not working.

What I expected is literally the same as in the documentary.

(https://livewire-powergrid.com/table/column-summary.html#withsum)

looking forward for the solution.
Thanks

[dansysanalyst]

You can create a custom theme and change the CSS.

For instance:

//...
class MyTheme extends Tailwind
{
    public string $name = 'tailwind';

    public function table(): Table
    {
        return Theme::table('rounded-lg min-w-full border border-slate-200 dark:bg-slate-600 dark:border-slate-500')
             //...
            ->tdBodyTotalColumns('px-3 py-2 whitespace-nowrap dark:text-slate-200 text-sm text-slate-600 text-left space-y-2');   //Align left
//...