2 Replies Latest reply: Feb 26, 2013 8:55 AM by minimuke

# Expressions Limits

I know it is possible to limit dimensions to only show value greater or less than a certain number.

I have this expression:

sum({\$<[Margin Account] =>} MARGIN)

This is used in a straight table and I would like to only display values above £10, 000, 000. How would I do that?

• ###### Re: Expressions Limits

This will show you the sum of MARGIN where Margin Account is > 10,000,000:

sum({\$<[Margin Account] = {'>10000000'} >} MARGIN)

This returns the sum of MARGIN where MARGIN is > 10,000,000 and selections in Margin Account are disregarded:

sum({\$<[Margin Account]=, MARGIN={'>10000000'} >} MARGIN)

This returns a value if the sum of MARGIN is > 10,000,000:

If(sum(\$<[Margin Account]=>}MARGIN)>10000000),sum(\$<[Margin Account]=>}MARGIN)>10000000))

Not sure which one you're looking for.

• ###### Re: Expressions Limits

i need to display the results where SUM of MARGIN > 1000000, not the MARGIN

so if it was a dimension, i could just choose to show values that are greater than 100000