Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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])
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
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
Thanks Sunny. This worked