Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
We have a straight table and has multiple columns.
1. Sales value
Expression:
= if($(sales)>=1000000000 ,NUM($(sales)/1000000000,'$#,###.0B'),
if($(sales)<1000000000 and $(sales)>=1000000, NUM($(sales)/1000000,'$#,###.0MM'),
NUM($(sales)/1000,'$#,###.0K'))
)
2. Other columns
We kept sorting on the sales column.This works fine when we have all thee vlaues in one group either B or MM or K. when mixed group comes up we this sorting does not work. Is there any way I can sort all in the raw sales data and use that for sorting instead of display column?.
Sales | Previous Day Change | Net Change | Actual Sales |
$100 K | 1% | 0.25% | 100000 |
$98 B | 2% | 0.25% | 98000000000 |
$3 M | 3% | 0.25% | 3000000 |
Yes. You can sort by expression.
Just set expression = sum(sales).
Also, Why the if/then with the num function? On the Number tab there is a space for Symbol, Thousand Symbol, Million Symbol, Billion Symbol - you can use these and it will take care of the formatting for you without having to break it up.
Sort column expression is disabled. Is there any way I can enable it?.
Hmm. I don't know! I haven't seen that disabled before.
User Preferences - Design - Default Styling Mode = Advanced, maybe?
Or Document Properties - General - Styling Mode = Advanced?