Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
THRUST SERVICES & TOOLS
CLOUD EDITIONS
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
Format Number
ReinerE
Hi all,
I just want to format the variance between two columns.
For the calculation I choose a Data element. In the property editor / format as Custom
I wanted something like this + ###,##0; - ###,##0. But it didn't work. Any idea?
Thx in advance!
Reiner
Find more posts tagged with
Comments
mcremer
<blockquote class='ipsBlockquote' data-author="'ReinerE'" data-cid="83027" data-time="1316507065" data-date="20 September 2011 - 01:24 AM"><p>
Hi all,<br />
<br />
I just want to format the variance between two columns.<br />
For the calculation I choose a Data element. In the property editor / format as Custom<br />
I wanted something like this + ###,##0; - ###,##0. But it didn't work. Any idea?<br />
<br />
Thx in advance!<br />
<br />
Reiner<br /></p></blockquote>
<br />
Hey Reiner first of I wanna ask is the Data element set to String or to a Float or a Number?<br />
<br />
if its a String you can use somting like:<br />
<br />
@<
;br />
<br />
If its a float number somting like you writen:<br />
###,##0.00<br />
<br />
The negative will always be shown.
