AnsweredAssumed Answered

Script not calculating correctly?

Question asked by NickLawrence on Oct 30, 2015
Latest reply on Oct 30, 2015 by karimhanafi

Hi all,


I have a slight problem with a part of a script, the part I'm having problems with is as follows:


Round ( Contracts::Agreed charges 07 MSC percentage / Get ( FoundCount ) ; 2 ) for some reason, even though the field that it refers to is populated with a number it returns 0.00, I've checked the field and it is set up as a number, the format for the number is decimal with fixed decimal place of 2 and the amount entered is 0.1 showing as 10%. At first I thought it was because it was 0.1 and the round function was causing it to zero, however I have put 100 in there and still get zero, doesn't matter what number I put in the Contracts::Agreed charges 07 MSC percentage field, I always get 0.00 as the result. However, if I change the script to Round ( 100 / Get ( FoundCount ) ; 2 ) I get the correct result, so it is obviously a problem with it looking at that field.

Anyone have any ideas why this would be doing this? And how I can fix it?

Many thanks