how to get value from expression to array

[#1]

Hi!

I have table with dimention - country and expression = if(Sum (Sale)> 10000,Sum (Sale), )

I know how to get value from field -

set sale=ActiveDocument.Fields("Sale").GetSelectedValues

Maybe you know how to get values from my expression if(Sum (Sale)> 10000,Sum (Sale), )

Please help, if you can

[#2]

may be somebody know how to get value from dimention with expression?

[#3]

  hi ,

Use the below expression

=concat(Aggr(if(Sum (Sale)> 10000,Sum (Sale)),Country), ',')

Pleas find the Attached app.. hope it helps you..

[#4]

Hi, thanks for your help!

How can i then get this values into array. Grom field i know it is like this:

set val=ActiveDocument.Fields("Sale").GetSelectedValues

I need something like this: set val= concat(Aggr(if(Sum (Sale)> 10000,Sum (Sale)),Country), ',')

[#5]

Hi

check the attached Application..

Hope it helps you..

[jonathandienst]

Hi

I assume that you want to evaluate this expression in a VBscript module?

result = ActiveDocument.Evaluate("if(Sum (Sale)> 10000,Sum (Sale))")

Hope that helps

Jonathan

[#7]

unfortunatly i need get values real-time/ if i change filter - arrow must change to

[#8]

Hi!

thank you for help.

yes, i need expression in macro. But i need fill array with values of this expression.

i can fill array from field, using this: set val=ActiveDocument.Fields("Sale").GetSelectedValues

now i need fill my array with values from my expression - please look attachment in topic.

i already try to create table with dimention with this expression, and i can't fill aray with value of dimentons with expression

[#9]

Hi,

Create a variable in Front end and i think that will suffice..

Please check the attached app...

If this is not the required one.. please send us the Output format which is required

[#10]

solve using by GetCell