Error in Expression: ')' expected

[#1]

Greetings,

I'm trying a simple sum but have 2 different formats to return the data, dependant of the data which is selected to be shown. The elements are set using a variables:

vDisplayFormat (This should set the formatting to use)

• Cost      R # ##0;R # ##0
• Time      ##0

vDisplay (This refers to the field where the data resides)

• Cost      Total
• Time      No. Hrs Worked

Expression I'm using is:

=NUM(SUM($(vDisplay)),vDisplayFormat)

This works for the Cost formatting, but the Time formatting returns the Error in Expression: ')' expected

The idea is to return the:

1. SUM of Total in R # ##0;R # ##0 format
2. SUM of No. Hrs Worked in ##0 format

Any ideas?

Message was edited by: Chris Evans

[johanlindell]

Try =NUM(SUM($(vDisplay)),'$(vDisplayFormat)')