individual row format possible

[Anonymous]

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

[its_anandrjs · Accepted solution]

It is correct only remove * 100 because you all ready use % format as '##.00%'

=num((Balance  / [Prev Bal]), '##.00%')

Regards

Anand

[Anonymous]

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

[Anonymous]

Hi Anand

After your suggestion, I selected 'Expression Default' in Number tab and working perfectly fine.

I appreciate your answer and thanks