Aggregation in VBE

[UCL_Will]

I'm experimenting with the aggregation of results in VEDA-BE.  I need to create a ratio of alternative transport fuel across many scenarios and years and the aggregation tool would be very useful for this.

Here is my expression:

( {ALLALCOHOLS} + {ALLBIO} + {ALLELECTRICITY} + {ALLOTHERRNW} )  / ({ALLALCOHOLS} + {ALLBIO} + {ALLCOALS} + {ALLELECTRICITY} + {ALLGAS} + {ALLHEAT} + {ALLHYDROGEN} + {ALLNUCLEAR} + {ALLOILPRODUCTS} + {ALLOTHERRNW})

I enter this under CommoditySet | ExprBldr

Unfortunately I can't get this to work.

Is there any documentation on this?  Is this feature fully operational?

Regards,

Will

[AKanudia]

This is way too complex even for what it was designed to do. Simple expressions can work but I strongly recommend that you restrict the use of this functionality to ENUMERATE. I would use Excel Export/Update and do the formulas in Excel.

[UCL_Will]

Hi Amit.

Thanks for the quick reply.  This is a shame - as a quick formula here would be a very efficient means of doing this - it is very clunky in Excel...

=(SUMIFS(Sheet1!E$5:E$503,Sheet1!$B$5:$B$503,Sheet2!$B19,Sheet1!$C$5:$C$503,Sheet2!$C19,Sheet1!$D$5:$D$503,Sheet2!$Q19)
+SUMIFS(Sheet1!E$5:E$503,Sheet1!$B$5:$B$503,Sheet2!$B19,Sheet1!$C$5:$C$503,Sheet2!$C19,Sheet1!$D$5:$D$503,Sheet2!$R19)
+SUMIFS(Sheet1!E$5:E$503,Sheet1!$B$5:$B$503,Sheet2!$B19,Sheet1!$C$5:$C$503,Sheet2!$C19,Sheet1!$D$5:$D$503,Sheet2!$T19))
/SUMIFS(Sheet1!E$5:E$503,Sheet1!$B$5:$B$503,Sheet2!$B4,Sheet1!$C$5:$C$503,Sheet2!$C4)