1, 2, 4, 8, 16, 32, 64…

[Stuart Taylor]

What is the best way to calculate the following incrementing results in to a repeating field using the Get (CalculationRepetition) function

Rep 1 = 1

Rep 2 = 2

Rep 3 = 4

Rep 4 = 8

Rep 5 = 16

Rep 6 = 32

Rep 7 = 64

Rep 8 = 128

Rep 9 = 256

Rep 10 = 512…

I am sure i have done this simply before but can not remember how or locate it.

many thanks

Stuart

Edited October 15, 2008 by Guest

[comment]

How about:

2^( Get ( CalculationRepetitionNumber ) -1 )

[David Jondreau]

This comes to mind...

2 ^ (Get(CalculationRepetition) -1 )

[IdealData]

I Removed my post coz it was total gibberish

Edited October 15, 2008 by Guest

[Stuart Taylor]

Many thanks ^ is the little fella i was looking for. I don't use him very often so he took an extended vacation from my mind. He is now back in the office and hard at work.