Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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))
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))
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)
Can you try this
=sum({<[Tree Name]=,[Tree Group]={'$(=only([Tree Group]))'}, [ID]=,[Number Of Trees]= >} $(=vExpTotal )* 1000)
this is not the correct answer
this is not the correct answer
Why did you mark it as correct response my friend?
I did not say "my answer is correct". I just asked to try like this?
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?