Expand my Community achievements bar.

SOLVED

LiveCycle Error

Avatar

Level 4

Capture.PNG

I am getting this error when I open my form. All I'm trying to do is calculate the sum of a few fileds to a totals field. Any suggestions?

1 Accepted Solution

Avatar

Correct answer by
Former Community Member

It shoudl be Sum(Field1.rawvalue, Field2.rawValue etc....)

The easiest thing to do now is simply remove the word Sum as by adding all of thse fields you are doing a sum.

Paul

View solution in original post

3 Replies

Avatar

Former Community Member

The Sum function takes a series of fields - separated by commas - and adds them together. You have added + signs to separate your fields.

Paul

Avatar

Level 4

This is what I have in the totals field which is field 14:

Sum(NumericField6.rawValue

+ NumericField10.rawValue + NumericField11.rawValue + NumericField12.rawValue + NumericField13.rawValue + NumericField14.rawValue);

Show: Calculate

Language: FormCalc

Run at: Client

I've tried to troubleshoot but nothing is working for me.

Avatar

Correct answer by
Former Community Member

It shoudl be Sum(Field1.rawvalue, Field2.rawValue etc....)

The easiest thing to do now is simply remove the word Sum as by adding all of thse fields you are doing a sum.

Paul

The following has evaluated to null or missing: ==> liqladmin("SELECT id, value FROM metrics WHERE id = 'net_accepted_solutions' and user.id = '${acceptedAnswer.author.id}'").data.items [in template "analytics-container" at line 83, column 41] ---- Tip: It's the step after the last dot that caused this error, not those before it. ---- Tip: If the failing expression is known to be legally refer to something that's sometimes null or missing, either specify a default value like myOptionalVar!myDefault, or use <#if myOptionalVar??>when-present<#else>when-missing. (These only cover the last step of the expression; to cover the whole expression, use parenthesis: (myOptionalVar.foo)!myDefault, (myOptionalVar.foo)?? ---- ---- FTL stack trace ("~" means nesting-related): - Failed at: #assign answerAuthorNetSolutions = li... [in template "analytics-container" at line 83, column 5] ----