get_opportunities_data(); select 0 as active, 0 as sold, 0 as nosale, 0 as activeimpact, 0 as soldimpact, 0 as nosaleimpact, 0 as lost, 0 as lostimpact, 'UOM' as uom
Opportunities
Active #numberformat(int(val(result.active)),"9,999")#
TY Impact #numberformat(int(val(result.activeimpact)),"9,999")#
Sold #numberformat(int(val(result.sold)),"9,999")#
TY Impact #numberformat(int(val(result.soldimpact)),"9,999")#
Lost #numberformat(int(val(result.lost)),"9,999")#
TY Impact #numberformat(int(val(result.lostimpact)),"9,999")#
No Sale #numberformat(int(val(result.nosale)),"9,999")#