Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
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.
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