Conditional formatting in rounded values -

-

facing trouble in cognos 10, in report have apply conditional formatting values less 0 (except zero) red, applying round-off 0 decimals. problem values -0.1 getting rounded-off 0, shown in red due conditional formatting.

is there work around show rounded 0 values in black?

try rounding off value on condition on conditional style too. these:

round(([columnvalue]*100),0) < 0

then set foreground color or background color red. hope helps.


Comments

Post a Comment

Popular posts from this blog

javascript - How to name a jQuery function to make a browser's back button work? -

-
i'm trying write function ajaxyfy web site, works perfect, except function button. that's have now: function loading() { if (typeof history.pushstate !== "undefined") { var historycount = 0; $('.menu-item, .logo').on('click','a',function(e){ e.preventdefault(); $(this).data('clicked', true); if ($(this).is('.logo a')) { var homepage = $(this).attr('href'); function1(homepage); history.pushstate(null, null, homepage); } else if ($(this).is('.projects a')) { var projects = $(this).attr('href'); function2(projects); history.pushstate(null, null, projects); } else { var pages = $(this).attr('href'); function3(pages); history.pushstate(null, null, pages); ...
Read more

java - gson parse items from comma-separated-value string within a json value -

-
i parsing json string using gson . similar this: { "acode": "aa", "rcode": "rr", "errors": "e1,e2,e3" } i think errors should have been proper json array, don't have control of that. i want errors array or collection in java . easy enough using string.split comma separator. new gson , don't know if ignoring functionality provides parse comma separated string. does know whether gson can handle automatically? i want errors array or collection in java. try one string json = "{\"acode\": \"aa\",\"rcode\": \"rr\", \"errors\": \"e1,e2,e3\" }"; class errorsdeserializer implements jsondeserializer<string[]> { public string[] deserialize(jsonelement json, type typeoft, jsondeserializationcontext context) throws jsonparseexception { return ((jsonobject) json).getasjsonprimitive(...
Read more

Validation in java Error log in register -

-
i trying set validation of confirm password , textfield must have value in it. im beginner sir im practicing build log in , register program. sorry english im not great in speaking english. my problem code not running fine. keeps telling "fill spaces" string username = usernamefield.gettext(); string password = passwordfield.gettext(); string cpassword = cpasswordfield.gettext(); if ((username != null) || (password != null) || (cpassword != null)) { if (password == cpassword) { db.insertdata(username, password); joptionpane.showmessagedialog(null, "data has been entered"); } else { joptionpane.showmessagedialog(null, "please fill spaces"); } } else if (password != cpassword) { joptionpane.showmessagedialog(null, "password mismatch"); } if((username != null) || (password != null) || (cpassword != null) ){ if(password.equals(cpassword)){ db.insertdata(username, password); joptio...
Read more