Try:Let(result = XXX + YYY ;If ( result > 0 ; "+" ) & result)
No visible sign is the standard notation for positive numbers. There is no built in formatting option to show a plus sign.
If you make yoru field of type text, it can display the + sign.
You might also set up a + sign as layout text that uses conditional formatting to be invisible when the value of this field is less than 0, but such couldn't be located to the left of the highest order digit like you show in your example text.
i almost got excited, it works if i format the field as "general" but unfortunately i need to display 2 decimal characters and the + or - operators (even if they are zero)
sorry i didnt think to includethis in the original post, thanks
Can you give me some real examples of what you have and what you want ?
BTW: try this one:Let([result = n1 + n2 ;decimal = Mod ( Abs ( result ) ; 1 )];Case ( result > 0 ; "+" ; result < 0 ; "-" ) & Int ( Abs ( result ) ) & Left ( decimal + 1/1000 ; 3 ))
Ray - You my friend ...are an absolute genius!!!!
im not very experienced and had to play around with the formating and field type, but your code worked a treat !!!
well done and thank you so much, i did try and figure this out the google way but couldnt
ps. thanks phil for your input, i did have a go at doing the labels in front of the fieldbox, but that proved a problem as i need to print as well.
thanks again guys