topic Re: Both Precedes and Follows in Set Analysis in App Development

Both Precedes and Follows in Set Analysis

simospa — Thu, 04 Nov 2021 09:20:39 GMT

Hi!

I'm trying to use precedes and follows in Set Analysis, and they are what I need: I saw the posts about them where @swuehl and @petter explained how to use "separately".

But I need to use them... both in the same Set Analysis for the same field.

For example: OrderNo between 'V21013238' and 'V21016423' (I set them into two variables, vOrderFrom and vOrderTo).

I tried to use:

Sum({$< [OrderNo ] = {"=[OrderNo ] follows '$(vOrderFrom)' "},
[OrderNo ] = {"=[OrderNo ] precedes '$(vOrderTo)' "}
>} [Amount])

but it doesn't work 😞

Any help please?

Thank you!

Re: Both Precedes and Follows in Set Analysis

tresB — Thu, 04 Nov 2021 09:25:59 GMT

Give a try like:

Sum({$< [OrderNo ] = {"=[OrderNo ] follows '$(vOrderFrom)' AND [OrderNo ] precedes '$(vOrderTo)' "}
>} [Amount])

Re: Both Precedes and Follows in Set Analysis

simospa — Thu, 04 Nov 2021 09:59:37 GMT

Thank you, it works!

I was not so far, but your solution is perfect!