Hello guys,
I have one table with multiple (hundreds of thousands) lines, those lines are related to servers and there multiple coluns on it, one of those are the Costs. There are multiple columns for the same server and with different costs, i dont know and i can't discover yet how each line is calculated, but probably is something related to the time of comsumption.
What I am trying to do it, related the servername and inject a fixed price for it, but this fixed price should be applied just once for all lines for the given servername.
Example : i have a server SRV01 and the total cost for it for the year is 1000, this 1000 is spread to multiple lines in the datasource, what i want to do is replace those multiple lines by just one value, let say 800.
I have tried to create a table with the prices and VM sizes and a relationship between this table and my other costs table where i have the same server size column, when i get the COST from the new table and the servername from the costs table, it brings me each line with the fixed price, but does not sum it, and need to sum to present the whole price for all vms or filtering by other field, like project name or country.
Do you guys know another way to do that?
