(Status,'WorkinProgressAnalyst'),
ROUND(11*(
(5*FLOOR((TODAY()-DATE(1996,01,01))/7) +
MIN(5,
MOD(TODAY()-DATE(1996,01,01), 7) +
MIN(1, 24/11*(MOD(NOW()-DATETIMEVALUE('1996-01-01 07:00:00'), 1)))
))
-
(5*FLOOR((DATEVALUE(CreatedDate)-DATE(1996,01,01))/7) +
MIN(5,
MOD(DATEVALUE(CreatedDate)-DATE(1996,01,01), 7) +
MIN(1, 24/11*(MOD(CreatedDate-DATETIMEVALUE('1996-01-01 07:00:00'), 1)))
))
),0),
IF(ISPICKVAL
(Status,'WorkinProgressDevelopment'),
ROUND(11*(
(5*FLOOR((TODAY()-DATE(1996,01,01))/7) +
MIN(5,
MOD(TODAY()-DATE(1996,01,01), 7) +
MIN(1, 24/11*(MOD(NOW()-DATETIMEVALUE('1996-01-01 07:00:00'), 1)))
))
-
(5*FLOOR((DATEVALUE(CreatedDate)-DATE(1996,01,01))/7) +
MIN(5,
MOD(DATEVALUE(CreatedDate)-DATE(1996,01,01), 7) +
MIN(1, 24/11*(MOD(CreatedDate-DATETIMEVALUE('1996-01-01 07:00:00'), 1)))
))
),0),
IF(ISPICKVAL
(Status,'WorkinProgressQA'),
ROUND(11*(
(5*FLOOR((TODAY()-DATE(1996,01,01))/7) +
MIN(5,
MOD(TODAY()-DATE(1996,01,01), 7) +
MIN(1, 24/11*(MOD(NOW()-DATETIMEVALUE('1996-01-01 07:00:00'), 1)))
))
-
(5*FLOOR((DATEVALUE(CreatedDate)-DATE(1996,01,01))/7) +
MIN(5,
MOD(DATEVALUE(CreatedDate)-DATE(1996,01,01), 7) +
MIN(1, 24/11*(MOD(CreatedDate-DATETIMEVALUE('1996-01-01 07:00:00'), 1)))
))
))),0))
This is my code and it giving me an error like
"Error: Incorrect number of parameters for function 'ROUND()'. Expected 2, received 1" Please help me... Thanks in Advance :)
1 resposta
The error means that you have a ROUND() function in your formula that is missing the second parameter.
For example, ROUND() should be:
ROUND(aNumberToRound, numberofDecimals).
the error means you have
ROUND(aNumberToRound)
Here is a link to a previous discussion in case it helps: https://success.salesforce.com/answers?id=90630000000h207AAA
