Formula do not calculate correctly

[ancecb]

Hi!

I'm using i-net Designer 11.2 for Crystal Report design.

I need sum, but seems like formula calculate fields without decimal part and on result it gives zero on decimal part. Could you help with this seems like I'm stuck? Maybe I need to use other formula.

-------------Formula I'm using now---
WhileReadingRecords;
NumberVar VAT0_Main_LC;
IF (({fld.Fld1} = "V_LC") AND ({fld.Fld8} = "0")) THEN VAT0_Main_LC:= VAT0_Main_LC + ToNumber({fld.Fld10});

-------------Data source-------------
Field1 | Field8 | Field10
V_LC | 0 | 71.94
V_LC | 0 | 341.22
V_LC | 0 | 0
V_LC | 21 | 4.13

-------------Result now-------------
412.00

-------------Result I need----------
413.16

 

[IanWaterman]

Why are you using variables

Just use a formula

If {fld.Fld1} = "V_LC" AND {fld.Fld8} = "0" THEN ToNumber({fld.Fld10} else 0

You can then use a simple summary sum on this formula.

What result does that give you?

Ian

 

[IanWaterman]

Removed too many brackets should be

If {fld.Fld1} = "V_LC" AND {fld.Fld8} = "0" THEN ToNumber({fld.Fld10}) else 0

Ian

 

[ancecb]

Tested, nothing, it gave "0".

I don't think that there is enough with ... THEN ToNumber({fld.Fld10}), because on data file condition {fld.Fld1} = "V_LC" AND {fld.Fld8} = "0" repeats more than one time.

Any other idea?

 

[IanWaterman]

Place that formula alongside your data and see what is returned.

Ian

 

[ancecb]

I replaced parameters with values: If {fld.Fld1} = "V_LC" AND {fld.Fld8} = "0" THEN VAT0_Main_LC:=((71.94)+(341.22)+(0)) else 0;

And result was 413.16. That is correct. But how to force to get same result with paramaters from souce file.

 

[IanWaterman]

Why are you still using a variable?

Please create a formula as I suggested and place this on report alongside your data.

If {fld.Fld1} = "V_LC" AND {fld.Fld8} = "0" THEN ToNumber({fld.Fld10}) else 0

What does the formula return?

Ian

 

[ancecb]

Sorry, but I don't undarstand what you mean with "alongside your data".

 

[IanWaterman]

I assume this data is in your details and returns

Field1 | Field8 | Field10
V_LC | 0 | 71.94
V_LC | 0 | 341.22
V_LC | 0 | 0
V_LC | 21 | 4.13

Place the formula in the details line too

Ian

 

[ancecb]

Sorry, but I don't undarstand what is the purpose of this data changing. I need to figure out where is problem on tmpl and how to improve it, because data file is generated automatically and there isn't possible to achange anything in data file.

 

[IanWaterman]

Your first post said

I need sum, but seems like formula calculate fields without decimal part and on result it gives zero on decimal part. Could you help with this seems like I'm stuck? Maybe I need to use other formula.

The formula I am suggesting will enable you to determine if its a crystal issue or a data issue.

I can not see your report so you need to tell us what is happening, if you do not want to do that then I can not help you.

Ian

 

[ancecb]

Please don't be angry on me, because I realy don't undarstand what are you trying to suggest to me. There I added data file I could download + tmpl. Could you advice where and what I need to set?

tmpl

https://docs.google.com/open?id=0B97948t1E9rSSWRZR2xibVVCek0

data

https://docs.google.com/open?id=0B97948t1E9rSVmFSNnlyb3gyNFk

 

[IanWaterman]

I can not down load these files at work.

I am struggling to help you because I now do not know how you have identified problem if you have not created a crystal report from your data set.

All I want you to do is instead of using the formula you have currently placed on report add another formula as I have suggested and tell us what it returns.

Ian