java - Calculation of BigDecimal -

-

i'm having problem getting calculation down. can addition, subtract, etc... i'm trying ((a - b)/b) in jasper reports.

here's i've tried far

${budget}.subtract($f{actual})/$f{budget}

but when compile it. says have expression problem. i'm using jasper studio expression editor

both $f{budget} , $f{actual} text fields , class java.math.bigdecimal

here's stace trace

net.sf.jasperreports.engine.jrexception: net.sf.jasperreports.engine.fill.jrexpressionevalexception: error evaluating expression :  source text : $f{budgeted}.subtract($f{actual}.divide($f{budgeted}))  @ com.jaspersoft.studio.editor.preview.view.control.reportcontroler.fillreport(reportcontroler.java:475)  @ com.jaspersoft.studio.editor.preview.view.control.reportcontroler.access$18(reportcontroler.java:450)  @ com.jaspersoft.studio.editor.preview.view.control.reportcontroler$4.run(reportcontroler.java:337)  @ org.eclipse.core.internal.jobs.worker.run(worker.java:53)      caused by: net.sf.jasperreports.engine.fill.jrexpressionevalexception: error evaluating expression :  source text : $f{budgeted}.subtract($f{actual}.divide($f{budgeted}))  @ net.sf.jasperreports.engine.fill.jrevaluator.evaluateestimated(jrevaluator.java:308)  @ net.sf.jasperreports.engine.fill.jrcalculator.evaluateestimated(jrcalculator.java:582)  @ net.sf.jasperreports.engine.fill.jrcalculator.estimatevariables(jrcalculator.java:181)  @ net.sf.jasperreports.engine.fill.jrfilldataset.next(jrfilldataset.java:1261)  @ net.sf.jasperreports.engine.fill.jrfilldataset.next(jrfilldataset.java:1235)  @ net.sf.jasperreports.engine.fill.jrbasefiller.next(jrbasefiller.java:1588)  @ net.sf.jasperreports.engine.fill.jrverticalfiller.fillreport(jrverticalfiller.java:149)  @ net.sf.jasperreports.engine.fill.jrbasefiller.fill(jrbasefiller.java:939)  @         net.sf.jasperreports.engine.fill.basefillhandle$reportfiller.run(basefillhandle.java:120)  @ java.lang.thread.run(unknown source)     caused by: java.lang.arithmeticexception: division 0  @ java.math.bigdecimal.divide(unknown source)  @ projectsummary_1398114778002_614232.evaluateestimated(projectsummary_1398114778002_614232:405)  @ net.sf.jasperreports.engine.fill.jrevaluator.evaluateestimated(jrevaluator.java:295)  ... 9 more

${budget}.subtract($f{actual}) return bigdecimal reference, cannot use division symbol / because supported primitives (and class wrappers when unboxed). so, should use bigdecimal#divide instead.

${budget}.subtract($f{actual}).divide($f{budget})

from question edit:

caused by: java.lang.arithmeticexception: division zero

your $f{budget} variable should not have 0 value. use ternary operator solve problem:

${budget}.subtract($f{actual}).divide( ($f{budget}.compareto(bigdecimal.zero) == 0 ? bigdecimal.one : $f{budget}) )

from new comment:

i need if $f{budget} 0 calculation field gets assigned 0 , number other wise.

just modify usage of ternary operator:

($f{budget} == null || $f{budget}.compareto(bigdecimal.zero) == 0)) ? bigdecimal.zero : $f{budget}.subtract($f{actual}).divide($f{budget})

Comments

Post a Comment

Popular posts from this blog

jQuery Mobile app not scrolling in Firefox -

-
i have mobile app built in jquery mobile. scrolling fine in chrome & safari, fails scroll in firefox on desktop. have other instances of same app, different features, , works across browsers. life of me, cannot figure this, please help! located here: http://re-brand.us/dsus/index.html seems bug in firefox: bug log . able scroll using keyboard not trackpad on mac. are using mac? i'll keep looking see if can find way around it.
Read more

c++ - How to add Crypto++ library to Qt project -

-
Image
i downloaded crypto++ source , compiled cryptlib project in visual studio 2013, , added generated .lib file qt project, made .pro file this: qt += core gui qt += sql greaterthan(qt_major_version, 4):qt += widgets target = untitled template = app sources += main.cpp\ mainwindow.cpp headers += mainwindow.h \ databasecontrol.h \ test.h forms += mainwindow.ui win32:config(release, debug|release): libs += -l$$pwd/ -lcryptlib else:win32:config(debug, debug|release): libs += -l$$pwd/ -lcryptlibd else:unix: libs += -l$$pwd/ -lcryptlib includepath += $$pwd/ dependpath += $$pwd/ win32-g++:config(release, debug|release): pre_targetdeps += $$pwd/libcryptlib.a else:win32-g++:config(debug, debug|release): pre_targetdeps += $$pwd/libcryptlibd.a else:win32:!win32-g++:config(release, debug|release): pre_targetdeps += $$pwd/cryptlib.lib else:win32:!win32-g++:config(debug, debug|release): pre_targetdeps += $$pwd/cryptlibd.lib else:unix: pre_targetdeps += $$pw
Read more

php array slice every 2th rule -

-
i have array on php outputs in txt file: printing grid -- 1 values -- undef = -9.99e+08 20.2 \nprinting grid -- 1 values -- undef = -9.99e+08 102.0 \nprinting grid -- 1 values -- undef = -9.99e+08 55.1 \nprinting grid -- 1 values -- undef = -9.99e+08 -18.3 \n what point, need nummeric values @ beginning of each rule. 20.2, 102.0, 55.1, -18,3 etc... example, there can more or less in txt file. now do? have tested array slice function can't exclude rule: printing grid -- 1 values -- undef = -9.99e+08 this array slice code... $arraygood = array_slice($arraybad, 1, 4); and foreach loop create text file: $file = fopen("array.txt","w"); foreach ($arraygood $meting => $waarde) { echo fwrite($file,$waarde . '\n'); } fclose($file); thanks! as posted in comments, understanding have array of strings similar following: $lines = array( "printing grid -- 1 values -- undef = -9.99e+08", "20.2 \nprinting grid --
Read more