Rajesh
I Agreed with Udayan. Though this is not clear wat exactly u want here, i think u need not get confused with (+)ve/(-)ve sign in numbers bcoz in BLS all calculations are self mathematically done with proper result.
Anyway, if it is strictly requirement of assignment for signs to numbers, u may use this expression as <b>-1 * ((A*B)-C)</b> for negative sign, otherwise <b>+1 * ((A*B)-C)</b> for positive sign.
Of course, all attributes must be Number Data Type to be calculated properly, otherwise set that attribute as number with use of built-in function <b>number(attribute)</b>
Regards
Som
Add comment