Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis

Hi Guys/Girls

I want to create a set analysis like such with a calculation at the end: so I set the producer group, but for that set i want to do a calculation

sum({$<[Producer Group] = {"Pool"}>}FOB?EXW/[Standard Carton Equivalent])

But that does not work...

Any help will be appreciated

Regards

Andre

1 Solution

Accepted Solutions
sorrakis01
Specialist
Specialist

Hi,


sum({$<[Producer Group] = {'Pool'}>}[FOB?EXW])

/

sum({$<[Producer Group] = {'Pool'}>}[Standard Carton Equivalent])

Regards

View solution in original post

3 Replies
marcus_malinow
Partner - Specialist III
Partner - Specialist III

Try this:

sum({$<[Producer Group]={"Pool"}>} [FOB?EXW]/[Standard Carton Equivalent])

sorrakis01
Specialist
Specialist

Hi,


sum({$<[Producer Group] = {'Pool'}>}[FOB?EXW])

/

sum({$<[Producer Group] = {'Pool'}>}[Standard Carton Equivalent])

Regards

sorrakis01
Specialist
Specialist

Hi,

In your expression you use double cuote

sum({$<[Producer Group] = {'Pool'}>}FOB?EXW/[Standard Carton Equivalent])