topic Re: calculation - range sum in App Development

calculation - range sum

joeybird — Wed, 28 Oct 2015 09:23:34 GMT

Hiya

I want to show difference for each department - per week

I have this calculation

rangesum( above( sum(ORDERS),0,rowno()))

its adding up the rows...I wish to show difference

e.g

week 1 = 30

week 2 = 35

difference is 5

Please help

Re: calculation - range sum

jonathandienst — Wed, 28 Oct 2015 09:45:04 GMT

For difference you just need:

=Sum(ORDERS) - Above(Sum(ORDERS)

Re: calculation - range sum

jonathandienst — Wed, 28 Oct 2015 09:45:59 GMT

If the table has multiple dimensions, you will need

=Sum(ORDERS) - Above(TOTAL Sum(ORDERS)

Re: calculation - range sum

jonathandienst — Wed, 28 Oct 2015 09:47:51 GMT

Assuming Department is the first dimension and date is the second:

=If(Department = Above(TOTAL Department), Sum(ORDERS) - Above(TOTAL Sum(ORDERS), 0)

Re: calculation - range sum

joeybird — Wed, 28 Oct 2015 10:11:24 GMT

Hiya

I get expression error

please help

Re: calculation - range sum

joeybird — Wed, 28 Oct 2015 10:16:21 GMT

Hiya

I got it to work with a slight change

Sum(Orders) - rangesum( Above(Sum(Orders)))

I have a number of weeks to show

e.g week 1, week 2, week, 3

I don't wish to show week 1

so chart with show

e.g

5, 12, ect

not

30, 5, 12

how can this be achieved please?

Kind Regards

Re: calculation - range sum

jonathandienst — Wed, 28 Oct 2015 11:45:48 GMT

=Alt(Sum(Orders) - Above(Sum(Orders)), 0)

Re: calculation - range sum

joeybird — Wed, 28 Oct 2015 12:59:18 GMT

Hiya

this is great

however

I have a customer, that has the value of e. 20

on my line chart he appears as -20, but as soon as you click on customer individually ... he appears as 20

any ideas why please