Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have rows
Q4
Prev Bal $40
Balance $60
Loss/Gain % 150.00%
I used num((Balance * 100 / PrevBal), '##.00%')
Still I am not getting % format
I appreciate your efforts
It is correct only remove * 100 because you all ready use % format as '##.00%'
=num((Balance / [Prev Bal]), '##.00%')
Regards
Anand
It is correct only remove * 100 because you all ready use % format as '##.00%'
=num((Balance / [Prev Bal]), '##.00%')
Regards
Anand
Hi Anand
Thanks for prompt reply
But in case of 0.00000004895% I want to see atleast 0.00% which does not happen here.
Still I can see 0
Thanks again
Hi Anand
After your suggestion, I selected 'Expression Default' in Number tab and working perfectly fine.
I appreciate your answer and thanks