Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)))
OK, it´s fine, thank you so much, greetings from Spain
Awesome 🙂