Is there an easy, out of the box, conversion to convert big decimals to Millions of Dollars in InfoAssist ('12,345,678.99' to '$12.345M'?
This image is from tableau. So I'm thinking: If tableau has it as an automatic conversion, then WebFOCUS should have something simple, if not automagic, to do this. Yeah, I know it's easy for chart creation. But, We need this for report creation in IA.
I know we can do the following. But, that's too complex for the average business users who is new to WebFOCUS.
MattC: Thanks so much! I just learned something totally new here. I never knew about this mask. And if you just type D12.2m inside the format box in InfoAssist, you get the number in millions. Outstanding!
WebFOCUS 8206, Unix, Windows
Posts: 1822 | Location: New York City | Registered: December 30, 2015