cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
salmaanmoh123 Frequent Visitor
Frequent Visitor

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

5 REPLIES 5
salmaanmoh123 Frequent Visitor
Frequent Visitor

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

Super User
Super User

Re: Calculations

Hi @salmaanmoh123

 

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
Community Support Team

Re: Calculations

Hi @salmaanmoh123,

 

Please post sample data and show us desired output. How to Get Your Question Answered Quickly

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
salmaanmoh123 Frequent Visitor
Frequent Visitor

Re: Calculations

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

 

Community Support Team
Community Support Team

Re: Calculations

Hi @salmaanmoh123,

 

For detailed advice, please provide sample data and your desired output.

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.