Expand my Community achievements bar.

SOLVED

simple calculation in ES8

Avatar

Level 1

i am trying to put a simple calculation with an if exception

if(Field2>Field3) then field1=(Field3-Field2)

I cannot get this basic thing to work and I am by no means a programmer.

Thansk for any help!

1 Accepted Solution

Avatar

Correct answer by
Former Community Member

If they are numeric fields the following FormCalc applies to field1.

// form1.page1.field1::calculate - (FormCalc, client)


if (field2 > field3) then

  field3 - field2

endif

Steve

View solution in original post

3 Replies

Avatar

Former Community Member

Place this script (as FormCalc) in the script editor under calculate:

if (Field2 > Field3) then Sum (Field3 - Field2)

else null

endif

null can also be 0, or whatever calculation you want.

Avatar

Correct answer by
Former Community Member

If they are numeric fields the following FormCalc applies to field1.

// form1.page1.field1::calculate - (FormCalc, client)


if (field2 > field3) then

  field3 - field2

endif

Steve

Avatar

Level 1

Thank you! I finally got htis to work. I don't know if the issue was the fact I was trying to put this all on one lline. Very helpful though.

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] ----