Hello!
I am trying to summarize the cost by department and division by monthly basis using transaction list from another app. The setup is set as how I would like to see but the sum of amount is not same as what I expect. Can you please help? Thanks in advance!
This is the logic I used to create a metric:
'PL GL Data'.'Net Amount (USD)'DBY SUM:'PL GL Data'.'PL L0','PL GL Data'.Division,'PL GL Data'.Department,'PL GL Data'.Month]tFILTER:'PL GLs'.'PL Cat 1'='PL Cat 1'."Headcount Costs"]
Here’s the PL GL Data transaction list. For sanity check, I filtered out “Headcount Cost” for PL Cat 1 and March 2023 transactions only. Total should be $9,100,788.45 but I am getting $9,124,046.48
![](https://uploads-eu-west-1.insided.com/pigment-en/attachment/f0ff4c8b-8242-4c5d-a22b-70d13452d6eb.png)
![](https://uploads-eu-west-1.insided.com/pigment-en/attachment/71e272c8-dc74-493c-8123-f80df744cd01.png)