Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guy,
I have a variable wich is set and calculated as Include statement in the script
vProject# = sum({$<[ForecastCategoryName] = {'Pipeline'},DateType = {'Snapshot Date'}>}[# Opportunity])
And the front end expression of the chart is defined as $(vProject#)
But now i have several dimensions like country and year which a want to slice and dice trough this calculation in the frond end
How do i write this properly?
sum({$<[Year] = {'2016'},($(vProject#)) will not work. Pls advice
Thanks!
Robbie
Try this
$(=only({$<[Year] = {'2016'}>}vProject#)
Regards,
Greeshma
Nope,
No resuls
Hey there,
First of all, your set analysis expression is wrong and invalid and it will return null. Try maybe, tweak it a bit like this:
sum({$<[ForecastCategoryName] = {'Pipeline'},DateType = {'Snapshot Date'}, [Year] = {'2016'} >} [# Opportunity])
With these you can do what you want
Regards,
MB
Perhaps This
=sum({$<[Year] = {'2016'} $(vProject#))
OR For testing check this
Aggr(sum({$<[Year] = {'2016'} $(vProject#)),[ForecastCategoryName])
or
Would you able to provide sample
No matter how you want to massage your expression
=sum({$<[Year] = {'2016'},($(vProject#))
you will not get that to work, as this a nested Sum statement which is not allowed.
You can go with miguelbraga's solution above, or you could try
=Sum({$<[Year] = {'2016'}>} Aggr($(vProject#), Year, chartdim1, chartdim2, ...))
Where chartdim1, chartdim2 is comma separated list of all (one or more ) the chart dimensions.