This content has been marked as final.
Show 2 replies

Re: Expressions Limits
Gysbert Wassenaar Feb 26, 2013 8:55 AM (in response to minimuke)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
minimuke Feb 26, 2013 8:55 AM (in response to Gysbert Wassenaar )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
