4 Replies Latest reply on Mar 28, 2016 11:52 AM by casey lee

# How to calculate

I'm trying to calculate

Since these field in the same column. I'm not sure how to calculate in above way.

Thank you

• ###### 1. Re: How to calculate

Hey Casey,

Something like this should work:

(SUM(IF [Pointname] = 'CoolingDegreeDays' THEN [Units] END) + SUM(IF [Pointname] = 'HeatingDegreeDays' THEN [Units] END))

/

SUM(IF [Pointname] = 'Load Total' THEN [Units] END)

• ###### 2. Re: How to calculate

You could use LOD for this:

({ fixed [Segment], [Category] : sum(if [Ship Mode] = 'Same Day' then [Quantity] end )} + { fixed [Segment], [Category] : sum(if [Ship Mode] = 'First Class' then [Quantity] end )} ) / { fixed [Segment], [Category] : sum(if [Ship Mode] = 'Second Class' then [Quantity] end )}

So here it is taking , 251+594 / 868.

You can change the pills based on what you have!

• ###### 3. Re: How to calculate

Hi

Pooja,

I used your calculation and i believe it should work... but somehow # doesn't matched.

I used below calculation but it resulting something else. Could you please help? could it be due my numeric value?

if you look at my screenshot site =10  with calculation below. it should equal to 4 instead of 1824...

• ###### 4. Re: How to calculate

I found the problem

the problem is its calculating through every days..

Is there anyway I could calculate based on the filter selection as date or??

As you can see on the below screenshot, after clear out the filter.

CoolingDegreeDays=953

HeatingDegreeDAys = 871

which equals to 1824  and 1824 was the result after using calculation.