Displaying an expression calculation as £, %, etc

[#1]

Hello everyone,

I'm having trouble getting some of my expressions to display properly.  I've created a series of expressions in Text Objects to show on the front page of a dashboard.

The formulas I'm struggling with are:

=Num(Sum([Let Date]-[Void Date]-1)) / (count(Address))

I need this one as '##.##'

=Count([Termination Reason])/14606

I need this one as '##.##%'

=Num(Avg(Current_Balance),Count ([Welfare_Reform_Alert]= 'Yes'), '£#,###.##')

This one says "expression OK", but doesn't actually display!

I also have a couple more where it won't display a comma, using:

, '###,###')

Can anyone point me in the right direction?

TYIA.

Regards

Alex

[Nicole-Smith · Accepted solution]

See the text boxes in the attached.