Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

This topic is 6664 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

Is it possible to have a calculation return its results into different repetitions.

For example: Having a calculation field with two repetitions, then have it return the "true" result of an "IF" statement in repetition [1] and "false" result in repetition [2]

Thanks in advance, as I can't find any references to this.

Mark

Posted

Ok

So, for example, we have a number field (field1) and we wish that a repeating field (Rep) shows "true" into the first repeatition if field1 > 5 and "false" into second repeatition in all other cases.

Given this is about what you wish, we need a new field (field2) with this calc:

Case(

field1 > 5;"true¶";

"¶false"

)

the calc for Rep will be:

GetValue ( Extend ( field2 ) ; Get ( CalculationRepetitionNumber ) )

Posted

The question is very confusing. One IF statement can have only one result: either TRUE or FALSE - no matter how many repetitions.

It IS possible to have different calculations going on in each repetition, e.g.:

Choose (

Get(CalculationRepetitionNumber) - 1 ;

2 + 3 ;

2 * 3

)

returns {5 ; 6}.

Posted

Thanks comment,

That's exactly what I was trying to achieve.

& thanks raybaudi, but I didn't want to have to create anymore fields.

Mark.

Posted

Hi MRH

the comment's calc always evaluates all the field repeatitions in a way that the final result isn't much like to have only a repeatition full loaded. (as I understood that you wished)

This topic is 6664 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.