Field Indeх

[Anonymous]

Hi,

Is it possible to use alternate state in the Field Indeх formula?

Thank you in advance,

Larisa

[swuehl]

What should be the use case for that?

[Anonymous]

There is a variable vMin '=Min(FieldIndex('FieldName', FieldName))'

This variable is defined in Variable Overview Window with the equal sign. For some reason it is important.

The variable vMin is used as an argument in some other formulas in the application.

So I need to canculate the variable vMin based on the alternat state.

[swuehl · Accepted solution]

Have you tried applying the alternate state identifier to the Min() function?

=Min({AS} FieldIndex('FieldName', FieldName))

[Anonymous]

Thank you, swuel!