Hi there

I have a quick question regarding the final output of a summary zero result.

I'm setting up a user import routine that needs to be very, very simple to use with checks and measures throughout.  The data that's being imported, due to its nature, always comes back to a summary value of zero.  This is the correct position.

I'm currently at the testing phase where I'm summarising the values field to get a total and the result is always displayed as  "-3.6e-11".  Now, I'm happy that's zero, but I want to use this in a custom dialog box: "Your check digit is"&sCheckDigit

Obviously I'd rather have "Your check digit is 0.00" displayed, rather than "Your check digit is -3.6e-11"

I can't format it because it's not being used on a layout, I can't use GetSummay because there's nothing to break on given the flat nature of the import.  

Any help really appreciated on this, thanks

 

 

Can't you simply round the sCheckDigit value? if you want to also format it to display 2 decimal places, you could use =

Let ( 
a = Abs ( Round ( sCheckDigit ; 2 ) )
;
"Your check digit is " & Int ( a ) & SerialIncrement ( ".00" ; 100 * Mod ( a ; 1 ) )
)

 

That's perfect Comment, thanks for your help

I can't use GetSummay because there's nothing to break on given the flat nature of the import.  

​btw, this

GetSummary ( aSummaryField ; aSummaryField /*the same one*/ )

returns the value of the summary field over the entire found set.

Edited June 10, 201510 yr by eos