Error:Garbage after expression

[jlfraile]

Hi, i´m just trying to execute a script related to chart visualization, but doesn´t work and shows "error Garbageafter expression ','

If(ValueList ('Actuals Up To Budget','Actuals Below Budget','Actuals Above Budget')='Actuals Up To Budget',
(RangeMin(Sum(Budget)-Sum(Actuals),0))/sum(Budget)),

If(ValueList ('Actuals Up To Budget','Actuals Below Budget','Actuals Above Budget')='Actuals Below Budget',
num((RangeMax(sum(Budget)-sum(Actuals),0))/sum(Budget),'$#,##0.00;-$#,##0.00'),
(RangeMax(Sum(Actuals)-Sum(Budget),0))/sum(Budget))

The most annoynig thing is each If clauses work, but they don´t when working together

Thanks for your help

[sunny_talwar]

Try this

If(ValueList('Actuals Up To Budget', 'Actuals Below Budget', 'Actuals Above Budget') = 'Actuals Up To Budget',

(RangeMin(Sum(Budget) - Sum(Actuals), 0))/Sum(Budget),

If(ValueList('Actuals Up To Budget', 'Actuals Below Budget', 'Actuals Above Budget') = 'Actuals Below Budget',

Num((RangeMax(Sum(Budget) - Sum(Actuals), 0))/Sum(Budget), '$#,##0.00;-$#,##0.00'),

(RangeMax(Sum(Actuals)-Sum(Budget),0))/Sum(Budget)))

[jlfraile]

OK, it´s fine, thank you so much, greetings from Spain

[sunny_talwar]

Awesome 🙂