4 Replies Latest reply on Sep 23, 2016 6:48 PM by Lance Martens

# Assistance required with a “Calculated Field” format

Hi All,

I would appreciate any assistance with how to configure my worksheet “Calculated Field” format?

Logic:

• I have 12 months’ worth of actual flux data at a sample rate of 1min
• I have created three worksheets each to determine a specific “Count” based on the respective “True” statement
• The “Count > 0.0% Flax” represents the total relative reference measure

• My challenge is that I’m unable to figure out how to create a calculated field to determine the % of when the flax is >0.5 and >1.25 relative to the Count  > 0.0% Flax reference measure

Required:

• Is there a way to combine a “Count” calculated field with that of a “true” statement calculated field, allowing me to simply place the new calculated field on the column shelf and get the a desired count result without having to introduce a “True” filter?
• This will also then enable me to easily create a % calculated field as outlined below

• Example of what I’m trying to accomplish:
• I need a calculated field that will enable me to determine the relative percentage of the following:
• Count  > 0.5% Flax / Count  > 0.0% Flax (the true statements need to be already incorporated)
• 147,746 / 506,370
• = 29.18%
• Meaning that 29.18% of the time the flax % was > 0.5% relative to the Count  > 0.0% Flax reference measure

My workbook is attached.

Any assistance will be appreciated,

Cheers,

Lance

• ###### 1. Re: Assistance required with a “Calculated Field” format

Is that what you wanted? go through the attached workbook. Let me know If you've any query.

Mahfooj

1 of 1 people found this helpful
• ###### 2. Re: Assistance required with a “Calculated Field” format

Hello Lance,

you can create calculated fields as follows

Count  > 0.0% Flax V2 - SUM(IF [ > 0.0% Flax] THEN 1 END)

Count  > 0.5% Flax V2 - SUM(IF [ > 0.5% Flax] THEN 1 END)

Then a ratio of these fileds

[Count  > 0.5% Flax V2]/[Count  > 0.0% Flax V2]

I attache the edited workbook.

I hope to have understood your question

Ivan

1 of 1 people found this helpful
• ###### 3. Re: Assistance required with a “Calculated Field” format

Hi Mahfooj,

Much appreciated for the assistance, you were spot on!

My understanding of configuring a calculated field has just been enhanced.

Cheers,

Lance

• ###### 4. Re: Assistance required with a “Calculated Field” format

Hi Ivan,

Thanx for providing yet another approach on how to resolve my challenge.

You and Mahfooj were both correct in your applications.

I have tagged Mahfooj’s answer as correct seeing that that was the first as you can appreciate.

Cheers again for the support mate!

Lance