Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
may be somebody know how to get value from dimention with expression?
hi ,
Use the below expression
=concat(Aggr(if(Sum (Sale)> 10000,Sum (Sale)),Country), ',')
Pleas find the Attached app.. hope it helps you..
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), ',')
Hi
check the attached Application..
Hope it helps you..
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
unfortunatly i need get values real-time/ if i change filter - arrow must change to
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
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
solve using by GetCell