Set Analysis and Growth Calculation

[#1]

Hi

I have a calculation which is failing and need some help. I am trying to calculate growth using two set analysis values, but its not working.

The set analysis values are below:

Sum({$<[Account]={"40K"}, [Date]={"01/12/2016"}>}[Sales]) .....so lets say this equals $100

Sum({$<[Account]={"40K"}, [Date]={"01/11/2016"}>}[Sales]) ......and lets say this equals $90

A normal growth sum looks like Sum(100-90)/90 and this would equal 11.1%

The attempt below fails when I go to divide (Bold) what am I doing wrong?

Sum({$<[Account]={"40K"}, [Date]={"01/12/2016"}>}[Sales])  - Sum({$<[Account]={"40K"}, [Date]={"01/11/2016"}>}[Sales]) / Sum({$<[Account]={"40K"}, [Date]={"01/11/2016"}>}[Sales])

[sunny_talwar · Accepted solution]

Try this:

(Sum({$<[Account]={"40K"}, [Date]={"01/12/2016"}>}[Sales])  - Sum({$<[Account]={"40K"}, [Date]={"01/11/2016"}>}[Sales])) / Sum({$<[Account]={"40K"}, [Date]={"01/11/2016"}>}[Sales])

or this

Sum({$<[Account]={"40K"}, [Date]={"01/12/2016"}>}[Sales])/Sum({$<[Account]={"40K"}, [Date]={"01/11/2016"}>}[Sales]) - 1

[#3]

Thanks Sunny. This worked