Set Analysis

[#1]

Good afternoon,

I have created my first Set Analysis in a Straight Table with the kind help of folks in the Community.

I am comparing data from one month to the next and showing the difference.

I would like to just show the difference above and below a certain number i.e. above 10,000 or less than 10,000.

Is there a straight forward way to do this or do I need to do this as part of the load?

Thank you

[sunny_talwar]

I think the scenario your mentioning might need you to use Above/Below function. You can learn about them here:

Missing Manual - Above() and Below()

[rubenmarin]

Hi Mitchell, check the attached document to see an example.

If I understand it right you will need two variables: one for operator and other for the value. In the expresion "Sum(V)" should be your actual expression.

In the Rules tab of the input box you can check how is configured the vCompareOperator variable

[#4]

Thank you - please send the attachment

[rubenmarin]

Hi Mitchell, it's in the post above, this is the link: