topic Re: Nested Variables not working - sum of variables only evaluating first variable in App Development

Nested Variables not working - sum of variables only evaluating first variable

DawidDaw — Thu, 02 Apr 2020 15:50:40 GMT

Hello,

Im developing a QS app in QS Enterprise server. I have multiple variables that are frequently summed. When I use the syntax I am used to it only sums the first part.

Example:

Variables:

vVar1 = 3

vVar2 = 5

Result I am getting (last should obviously be 8):

EXPRESSION used	=$(vVar1)	=$(vVar2)	=$(vVar1)+$(vVar2)
RESULT	3	5	3

If I flip the variables around ($(vVar2)+$(vVar1)) I get 5 as a result.

I tried different syntaxes, all return an error or nothing.

What I tried:

adding or removing $ in variables or expression
adding or removing = in variables or expression
moving around the brackets

Everything return an error or a " - " cell, except the above method which only sums the first one.

Any idea's?

Thanks!

Re: Nested Variables not working - sum of variables only evaluating first variable

sunny_talwar — Thu, 02 Apr 2020 17:10:18 GMT

What happens when you use RangeSum()?

RangeSum($(vVar1), $(vVar2))

Re: Nested Variables not working - sum of variables only evaluating first variable

DawidDaw — Fri, 03 Apr 2020 09:23:00 GMT

Hi Sunny,

It returns an empty value (-) 😞

Dawid

Re: Nested Variables not working - sum of variables only evaluating first variable

sunny_talwar — Fri, 03 Apr 2020 11:22:44 GMT

Would you be able to share a sample where we can see this behavior? On another note, do you need dollar sign expansion? Can you try this?

RangeSum(vVar1, vVar2)

Re: Nested Variables not working - sum of variables only evaluating first variable

DawidDaw — Fri, 03 Apr 2020 11:52:17 GMT

As I'm fully on server with database data, I would need to re-create everything from scratch. I'll see if I can work something out.

Unfortunately, using the rangesum without the expansion doesn't work either.

Maybe I should mention de variables are set analysis:

sum({$<financials_state={"Actual"}, costType={"DirectCost"}>} financials_amount_euro_tax_excl )

sum({$<financials_state={"Actual"}, costType={"IndirectCost"}>} financials_amount_euro_tax_excl )

Re: Nested Variables not working - sum of variables only evaluating first variable

sunny_talwar — Fri, 03 Apr 2020 11:57:57 GMT

I am just trying to throw out different ideas for you to try... does this work? basically adding extra parenthesis around each variable.

($(vVar1)) + ($(vVar2))

RangeSum( ($(vVar1)), ($(vVar2)) )

Re: Nested Variables not working - sum of variables only evaluating first variable

DawidDaw — Fri, 03 Apr 2020 12:04:56 GMT

Jup, thanks for the troubleshoot Sunny! Neither the first nor the second, both return " - ".

However I notice you don't use = sign when inserting variable. I always have " =$(vVar) in all cases and have NO equal sign in variable definition. This is the way it works for me (well, until now).

Can this be an indication?

Re: Nested Variables not working - sum of variables only evaluating first variable

sunny_talwar — Fri, 03 Apr 2020 12:14:49 GMT

Ya, you can try adding an equal sign and see if that works

=($(vVar1)) + ($(vVar2))

=RangeSum( ($(vVar1)), ($(vVar2)) )

Re: Nested Variables not working - sum of variables only evaluating first variable

DawidDaw — Fri, 03 Apr 2020 12:16:14 GMT

What I mean is, I always use the equal sign. Don't really know the difference but that's the way I've always done it.

Removing or adding the equal sign doesn't help 😞

Re: Nested Variables not working - sum of variables only evaluating first variable

sunny_talwar — Fri, 03 Apr 2020 12:20:03 GMT

Can you post screenshots to show the issue? It is difficult to know what you might have without seeing it

Re: Nested Variables not working - sum of variables only evaluating first variable

DawidDaw — Thu, 16 Apr 2020 12:27:48 GMT

Hi sunny,

Sorry for not getting back to you, I've been of work.

Our DB architects released a new version of the dataset. I cannot reproduce the issue with the new variables, the sums work fine.

I still have a non refreshed version of the original dataset, I'll investigate if I have some time. will post if I do.

Thanks anyway for your help!