number format

[raadwiptec]

hi

any solution to change the number format on a text object?

if(Month= 'Jan', sum({$<Years= {'2016'},material= {'0335'},[budget] = {'T'},Type={'OK'}>} Values)

+ sum({$<Month = {'Feb','Mar'},material= {'0335'},[budget] = {'TA'},Type={'NO'}>} Values))

I need it in this format -- € #.##0,00;€ -#.##0,00

[MK_QSL]

Money(

if(Month= 'Jan', sum({$<Years= {'2016'},material= {'0335'},[budget] = {'T'},Type={'OK'}>} Values)

+ sum({$<Month = {'Feb','Mar'},material= {'0335'},[budget] = {'TA'},Type={'NO'}>} Values))

,-- € #.##0,00;€ -#.##0,00)

[sushil353]

Try this:

num(

if(Month= 'Jan', sum({$<Years= {'2016'},material= {'0335'},[budget] = {'T'},Type={'OK'}>} Values)

+ sum({$<Month = {'Feb','Mar'},material= {'0335'},[budget] = {'TA'},Type={'NO'}>} Values)),

'€ #.##0,00')

HTH

[boorgura]

num(

if(Month= 'Jan', sum({$<Years= {'2016'},material= {'0335'},[budget] = {'T'},Type={'OK'}>} Values)

+ sum({$<Month = {'Feb','Mar'},material= {'0335'},[budget] = {'TA'},Type={'NO'}>} Values)),

'€ #.##0,00;€ -#.##0,00')