Expression Error

[ArjunPrasad]

Hi All,

i am trying to write below expression but facing error 

if(ValueList('Actuals Up To Budget','Actuals Below Budget','Actuals Above Budget')='Actuals Up To Budget',
RangeMin(Sum(Budget),Sum(Actuals)))/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)))

not able figure it out, can you suggest the issue.

Please find attached qvf.

Thanks,

Arjun

[morgankejerhag · Accepted solution]

One paranthese is wrong, this works:

if(ValueList('Actuals Up To Budget','Actuals Below Budget','Actuals Above Budget')='Actuals Up To Budget',
RangeMin(Sum(Budget),Sum(Actuals))/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)
)
)

Morgan Kejerhag
Senior Business Intelligence Consultant
Drake Analytics
http://www.drakeanalytics.se

[ArjunPrasad]

Thank you @morgankejerhag , its working now.🙂