FieldA * 100
* Get ( CalculationRepeatitionNumber )
Be sure to specify the repetitions for your calculation field in storage options.
Does it make sense the way that i'm wanting to build this? I wanted to only have 2 fields instead of 14.
Field A Repetitions (number field) Field B Repetitons (calculation field)
and so on and so on
So i need help writing the calculation field for Field B.
It will need to get the repetition of itself and multiply the same repetiton number in Field A times 100.
Can someone help me actully write out the calculation for Field B?
Please and thank you.
The correct syntax is
Field A * 100
As shown by Raybaudi.
Then you select 7 repetitions as the storage option for this calculation field.
But using repeating fields like this (Instead of a table of related values) are most often not the optimum database design to use.