Set Analysis to calculate Proportional Increase for positive values only

[kcville]

Hello

I have a Dimension 'Customer' and I would like to work out the proportion of increase from 2019 to 2020, only if they had a positive Sales.

Can anybody help me with the set analysis please to work out the Proportional Increase?

Kelly

Customer	2019 to 2020 Increase	Proportional Increase
CustomerA	-100
CustomerB	200	50%
CustomerC	200	50%
Total	400	100%

[H_Julian]

Just Create another Dimension Field in the Script:

if(Value>=0,Value)) as PositiveValue

and write the SetExpression with this Field