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:
- SUM of Total in R # ##0;R # ##0 format
- SUM of No. Hrs Worked in ##0 format
Any ideas?
Message was edited by: Chris Evans
