## Desktop

Frequent Visitor
Posts: 7
Registered: ‎11-22-2018

# Calculations

I am having trouble calculating consumption over a month times by 3 different prices. Anyone know how i can do this so that i can make a graph showing consumption over the month if it was times by 3 different prices?

Cheers

Frequent Visitor
Posts: 7
Registered: ‎11-22-2018

## Re: Calculations

So have 3 individual lines on a line graph, eg:

consumption times by price 1 (First line)

consumption times by price 2 (second line)

consumption times by price 3 (third line)

Cheers

Highlighted
Super Contributor
Posts: 787
Registered: ‎11-12-2018

## Re: Calculations

If I've understood correctly what you need, how about creating three additional columns in your data table:

Column1 = Table[Consumption]*Price1

Column2 = Table[Consumption]*Price2

Column3 = Table[Consumption]*Price3

and using those columns for the chart?

Community Support Team
Posts: 5,400
Registered: ‎09-21-2016

## Re: Calculations

Best regards,

Yuliana Gu

Frequent Visitor
Posts: 7
Registered: ‎11-22-2018

## Re: Calculations

[ Edited ]

Yes @AlB thats exactly what i mean. How do i go about doing that

Community Support Team
Posts: 5,400
Registered: ‎09-21-2016