Set Analysis & variables

[Anonymous]

Hi,

why is the following set analysis not working:?

sum({<Tree Name]=,Tree Group]={'$(=only([Tree Group]))'}, [ID]=,[Number Of Trees= >}  ({$(=vExpTotal )}* 1000))

this variable vExpTotal is using another variable. Do I have to do something  to the first variable?

[sunny_talwar · Accepted solution]

May be because you are missing some square brackets or is that a typo?

Sum({<[Tree Name]=,[Tree Group]={'$(=only([Tree Group]))'}, [ID]=,[Number Of Trees]= >}  ({$(=vExpTotal )}* 1000))

[Anonymous]

Does Syntax of your expression is okay?

Some where you forgot to place '[' bracket...and some where you forgot to place ']'..

may be this?

=sum({<[Tree Name],[ID],[Number Of Trees],[Tree Group]={'$(=only([Tree Group]))'}  >} ($(=vExpTotal ))*1000)

[#4]

Can you try this

=sum({<[Tree Name]=,[Tree Group]={'$(=only([Tree Group]))'}, [ID]=,[Number Of Trees]= >}  $(=vExpTotal )* 1000)

[Anonymous]

this is not the correct answer

[Anonymous]

this is not the correct answer

[sunny_talwar]

Why did you mark it as correct response my friend?

[Anonymous]

I did not say "my answer is correct". I just asked to try like this?

[Colin-Albert]

What does the variable vExpTotal hold?

This variable may be incompatible with the rest of your expression. 
What happens if you replace ($(=vExpTotal )) with a different field for testing?