5 Replies Latest reply on Aug 19, 2016 9:02 AM by David Li

# Calculated Field

Hi,

Need help to write a calculated field.

M0 %= M0/M0

M1%=M1/M0

M2%=M2/M0

M3%=M3/M0

and so on... M0 should be fixed and calculation should be done table down.

I dont want to use max or window max function to calculate.

I have also attached TWBX file.

Thanks

• ###### 1. Re: Calculated Field

Hi Youthesh! You can try something like:

```SUM([Remaining Volume]) / LOOKUP(SUM([Remaining Volume]), FIRST())
```
1 of 1 people found this helpful
• ###### 2. Re: Calculated Field

Calc1 = Fixed amount for M0: {FIXED : SUM(IF [Month] = 'M0' THEN [Remaining Volume] END) }

Calc2 = Fixed amount per month: { FIXED [Month]:SUM([Remaining Volume])}

1 of 1 people found this helpful
• ###### 3. Re: Calculated Field

Thank you.

It worked.

• ###### 4. Re: Calculated Field

Thank you.

It worked.

• ###### 5. Re: Calculated Field

That's great! Would you mind marking it as the correct answer to help others? Thanks!

1 of 1 people found this helpful