Help with Totals from portals

[adamworking]

Hi all

 

I've edited a wonderful example, previously shared by @comment

 

It basically has a list of orders which shows the date the order was made and the price (£) of the order.

 

If you head to the "Chart" Layout, it shows the number of orders by a certain month, and the value (£) of the orders. Can somebody please how I add a total for each year, so this would show Total Revenue and Total number of orders for each year?

 

Any help massively appreciated.

 

Cheers

 

Adam

 

For some reason it won't let me upload my sample file, but you can access it here:

https://www.dropbox.com/s/ywea05bmx1h5q3f/ComparisonChartSlots.fp7?dl=0

 

This was based on 'ComparisonChartSlots' by @comment found here:

ComparisonChartSlots.fp7.zip

[adamworking]

Anyone able to offer any advice on this? Many thanks Adam

[bruceR]

If you zip the file you can upload it.

[eos]

Try this:

 

ComparisonChartSlots_eosMOD.fp7.zip

 

Note that List() ignores empty fields, so you must make sure the intermediate results in the month slots are not empty (i.e. have at least a value of 0) to get lists with the correct length of 12 values.

[adamworking]

hi @eos that's brilliant, thank you.  Adam