Hi,
I’m sorry, but I don’t understand your question.
If you want add the “%” symbol at the end of the equation’s result, you simply should enter the symbol in the attribute: “Symbol to display at the end of calculated field”
Best regards.
Thread Starter
tda325
(@tda325)
I’m getting an answer like”0.41, when back of the napkin calculations tell me it should be 41%. In other words, if I want to know what percent of 8 that 3 represents, the calculation would (3/8)*100″%” = (.375)*100= 37.5%
If I’m not mistaken, the XIRR function is leaving off that last “*100”.
Hi,
If you want to know the 3 percent of the number 8, the equation is as you describe:
(function(){
return (3/8*100)+'%';
})()
or simply:
3/8*100
and enter the symbol “%” through the attribute: “Symbol to display at the end of calculated field” of the calculated field.
Best regards.
Thread Starter
tda325
(@tda325)
missing my point. XIRR should be presented as a percentage. Since the XIRR function isn’t doing that, and is always (so far as I can tell), coming up with a decimal number less than 1.0, I believe that it is skipping the last step in any percentage calculation which is “multiply by 100”.
