KoolReport's Forum

Official Support Area, Q&As, Discussions, Suggestions and Bug reports.
Forum's Guidelines

PivotMatrix number format #3096

Open Komuraiah A opened this topic on on Jul 17, 2023 - 2 comments

Komuraiah A commented on Jul 17, 2023

Hi Team, When I use the pivot matrix table in my report, I need to change the amount value format. for example, if my payment amount is $125000. then I need to show $1.25. can you help me with this issue asap. below am sharing an screenshot for where i need to change the value format

Komuraiah A commented on Jul 24, 2023

hi team, am still waiting for your response.

David Winterburn commented on Jul 27, 2023

Did you try to set the measured field meta to include "decimals" => 2 like this:

->pipe(new Pivot(...))
->pipe(new \koolreport\processes\ColumnMeta([
    "sales - sum" => [ // a measured field name format is "{field} - {operator}"
        "type" => "number",
        "decimals" => 2,
    ],
    "sales - count" => [ 
        "type" => "number",
        "decimals" => 2,
    ],
]))
->pipe($this->dataStore(...));

Build Your Excellent Data Report

Let KoolReport help you to make great reports. It's free & open-source released under MIT license.

Download KoolReport View demo
help needed

None