MRH Posted October 25, 2006 Posted October 25, 2006 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
Raybaudi Posted October 25, 2006 Posted October 25, 2006 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 ) )
comment Posted October 25, 2006 Posted October 25, 2006 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}.
MRH Posted October 26, 2006 Author Posted October 26, 2006 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.
Raybaudi Posted October 26, 2006 Posted October 26, 2006 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)
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now