Formatting of zero result summary

[Stu412]

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

 

 

[comment]

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 ) )
)

 

[Stu412]

That's perfect Comment, thanks for your help

[eos]

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, 2015 by eos