Expression Error

Report Inappropriate Content · ‎2014-10-27

Dear All,

Please help me to find the error in following expression.

ROUND(ONLY(IF(SUB='FIN',GRO_PRE*.01)={"<0"},SUM(IF(SUB='FIN',GRO_PRE*.01))))

Regards,

Priyantha.

PrashantSangle · ‎2014-10-27

Hi,

Try like this

ROUND(ONLY(IF(SUB='FIN',GRO_PRE*.01)<0,SUM(IF(SUB='FIN',GRO_PRE*.01))))

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

anbu1984 · ‎2014-10-27

ROUND(ONLY(SUM(IF(SUB='FIN' And GRO_PRE*.01 <0,GRO_PRE*.01))))

tresesco · ‎2014-10-27

It seems that the expression could be optimized. However, that would require more information like, where you are using this expression(chart/text box/..), what you expect the output to be...Otherwise, syntactically if you want the correction, it might be like:

ROUND(ONLY(IF(SUB='FIN',GRO_PRE*.01)<0,SUM(IF(SUB='FIN',GRO_PRE*.01))))

suresh_rawat · ‎2014-10-27

Hi,

Use This :

ROUND(ONLY(IF(SUB='FIN',GRO_PRE*.01)<=0,SUM(IF(SUB='FIN',GRO_PRE*.01))))

Regards

Suresh Rawat

Related Topics