Expression problem

[#1]

Hi all,

I am trying to get the sum of "Supply OG" where it does not take into account the year selected and only displays that of "Saurian Petroleum"

Here is my expression, when I just have the year section it works but shows all companies and when I add in the Saurian Petroleum section it only returns the values of Saurian but now also only returns the values for the currently selected year.

Sum

( {<Year=>} {$<Company={[Saurian Petroleum]}>} [Supply OG])

I am assuming there is a proper way to connect the two modifiers but I do not know the code.

Hopefully someone can help me.

Thanks,

Kosta

[#2]

Hi

try this

Sum

( {<Year=, Company={'[Saurian Petroleum]'}>} [Supply OG])

regards

chris

[#3 · Accepted solution]

You can add multiple filters within {<...>}, so try this:

Sum

( {<Year=,Company={[Saurian Petroleum]}>} [Supply OG])

[manideep78]

try this

Sum({$<Year=,Company={[Saurian Petroleum]}>}[Supply OG])

[#5]

try

Sum({$<Year=,Company={'Saurian Petroleum'}>}[Supply OG])

Regards

Borys