Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
See the text boxes in the attached.
See the text boxes in the attached.