Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
I want to Different number formats in Straight Table Expressions.
For Operating Income is $, For NOI Margin is %
How can it possible?
Account | Amount |
Income | 6,000 $ |
Margin | 27.8% |
Regards,
Try this:
Create a straight table with Account as Dimension,
Expression:
if(Account='Income',num(sum(Amount),'#,###'),
if(Account='Margin',num(sum(Amount)/100,'##.#%')))
In chart properties > Number >Select Expression Default.
Thanks and regards,
Arthur Fong
Try this:
Create a straight table with Account as Dimension,
Expression:
if(Account='Income',num(sum(Amount),'#,###'),
if(Account='Margin',num(sum(Amount)/100,'##.#%')))
In chart properties > Number >Select Expression Default.
Thanks and regards,
Arthur Fong
Askin, did Arthur's suggestion work for you? If so, do not forget to return to the thread and use the Accept as Solution button on his post to give him credit for the help and to let other Community Members know it did work. If you are still working on things, leave an update on what you still need.
In these cases, attaching a sample QVW file can be helpful too.
Regards,
Brett