Expand my Community achievements bar.

Dive into Adobe Summit 2024! Explore curated list of AEM sessions & labs, register, connect with experts, ask questions, engage, and share insights. Don't miss the excitement.
SOLVED

Need help with an if statement

Avatar

Former Community Member

I have three variables: subA, subB, and subC. Originally I had the math such that (subC=subA/subB) and then I implemented a pattern so subC showed up as a percentage. That resulted in the possibility of subC being > 100%, which the client did not like. They asked if subC > 100%, that N/A appear. So I wrote the following script, which I'm sure is wrong because I don't have a lot of scripting experience and I got a syntax error. Thank you in advance for your assistance.

 

form1.#subform[9].subC::calculate - (FormCalc, client)

 

if (subC > 1) then

     subC = "N/A"

elseif  (subC <= 1) then

     (subA/subB = subC)

endif

1 Accepted Solution

Avatar

Correct answer by
Former Community Member

Good to hear. If you mark as answered, it will save other's from reviewing the thread.

View solution in original post

3 Replies

Avatar

Former Community Member

You are looking at the value of subC before you assign a value to it.

Maybe:

subC = subA/subB

if (subC > 1) then

     subC = "N/A"

endif

If a number field, you'll probably get an error setting it to a string though. You'll probably have to change to a Text Field and probably have to accomodate the "N/A" in the pattern.

Avatar

Correct answer by
Former Community Member

Good to hear. If you mark as answered, it will save other's from reviewing the thread.

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