on 02-08-2013 7:07 AM
Hi All,
Our issue is if amount is 4500 then we want 45.00
or 500 then we want 5.00
if amount 50 we want 0.5
if amount is 50000 then 500.00
is it pissible in graphical mapping?
Please give me a good suggestion?
Thanks in Advance,
vishnu p.
Hi,
Use Divide by function followed by format num...(mention here format as .00)
only thing here will be decimal numbers will be followed by number of zeros you mention...
e.g. 50 will be 0.50 insead of 0.5.. and hope that should not be a problem
HTH
Rajesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
In real time, you wont be getting any space but a blank value. In that case you can use "MapWithDefault" just after the source value and put "0" in this. This will solve your issue.
But still if you are sure that you can get a space you can go ahead with using "IfElseThen" using condition that If the source value == " " (space) then Pass a constant "0" Else use the Source Value.
Thanks
Anand
User | Count |
---|---|
94 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.