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

[MarcoWedel]

please post sample app

thanks

regards

Marco

[nithin_miryala]

try $(vDisplayFormat)

[#4]

Hi, I tried that before using the forum, doesn't work.

[#5]

Sample app is uploaded

[sasiparupudi1 · Accepted solution]

your No. Hrs Worked should be [No. Hrs Worked] or "No. Hrs Worked"

[#7]

try like this

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

[#8]

Thanks ... simple solution

[#9]

This is the answer, just need to adjust the variable action to one of the above and it will work fine

[#10]

Didn't work ... but we got to the solution