Forum Discussion
- QuickBaseCoachDQrew Captainnp
Edit the field properties and set the # of decimals to 2- JoshuaHamiltonQrew Trainee... I'm a moron, thank you. I can't believe I overlooked that
- QuickBaseCoachDQrew Captain:) Nothing in Quick Base is hard, but there are 1,000 easy things to know. So you just need to trip 1,000 times once to nail them all.
- JamesHoltonQrew TraineeSimilar question. I have it set where it pulls correctly to 2 decimal places on any forms or tables. However, when I try to pull a field into a mailto: it loses the formatting. I saw a previous post of yours recommending using round to solve the problem for cutting it down to 2 points. That solved that problem. Now the only issue is when there is a 1.1 as in above it is losing the 0 and I need it added back.
- RobertScaliseQrew CadetThanks for the tip. As I needed to display negative values in red, I went with the following approach. I just check how many characters are after the decimal after formatting, then I add back ad is needed.
var text txtRounded = ToFormattedText(Round([yourvalue]*100,0.01),"none_dot");
var number wheredot=If(Contains($txtRounded,"."),Length(Right($txtRounded,".")),0);
var text fmtnbr = If($wheredot = 0, $txtRounded & ".00", If($wheredot = 1, $txtRounded & "0", $txtRounded)) ;
If([yourvalue] < 0, "<span style='color: #EA3C53'>" & $fmtnbr & "</span>",$fmtnbr) - JamesBlackfordQrew MemberHow to format to one place decimal using code from Robert (above)?
Want to show 00.0%