So I was trying to get some value using formula in my aggregate, and the value shown is 0, but when i tried to use the value given in if statement, the application always return false value, even when it should've been true.
Sorry if the explanation is poor, because I myself didn't know how to describe it. Please see the images below for more information.
As seen above, the value from RumusFormulaSelisih is 0, and value in TotalCheckSubmit is always false, when it should've been true. RumusFormulaSelisih is also should've been zero integer since i cast it into integer, and all of the reference value is from integer.
Hi,
try to copy the RumusFormulaSeleisih value to totalChecksubmit value directly:
if((texttoeinteger(-(jmlsaat ini-jmllalu)))..blabla,true, false)
regards
Hi, it didn't work because that was what I did in the first formula. I change it into this new setup (RumusFormulaSelisih) because i want to check and make sure the result is 0.
Both didn't work.
Hi @Samuel Susetia Davilantinov Nugraha I just used data from DB for me its working good, kindly check empty text data with "Text Null identifier" for Zero also its Working good and returns true as Answer.if you still facing a issue share an Oml .
Can you please make the formula quotation in group? As you can see in my pictures, all data including input is from group data or sum value
Hi Samuel,
on your if statement where you check the condition put it all between parentis ()
if((texttointeger ... or ..x=0),true, false)
I think it will resolve your issue
Regards
Nope, it's not the problem. Still returning false error
hi @Samuel Susetia Davilantinov Nugraha,
yes, i have tried as you mentioned and got answer. in Ramusformulaselishvalue instead of your expression use like this
(-(TextToInteger(jmLSHATINI))-TextToInteger(JMLIS)-summSum-AMOUNTSUMSum) -because first two variable you have mentioned is text others are long integer,
case 1: rams value not zero.
case 2: When Rams amount Zero.
i hope this will solve your issue
Hi Lavanya, I've tried and it didn't work. The Outsystems didn't even show the result whem i tried to cast JML1SaatIni and/or JML1Lalu. Moreover i also cast the RumusFormulaSelisih into Integer in the end, but it still couldn't read it as 0
Did you got result?
I worked fine for me