Jump to content

Get Amount Number!


This topic is 5784 days old. Please don't post here. Open a new topic instead.

Recommended Posts

You need to supply more information with this. Why are you doing this? Are you looking for the number '5' or are you looking for the third digit from the decimal point (hundred)

Link to comment
Share on other sites

Here's my stab at it:

Let([tt=Int(entry);ss=Length(tt)];

Replace ( tt ; ss-2; 1 ; "," & TextColor(Middle ( tt ; ss-2 ; 1 );16711680)) & "." & Middle(entry-tt & "00";2;2))

Provided you wish to colour the digit red in a text field with the number string ...otherwise can you tear appart the components to get what you're after.

--sd

Link to comment
Share on other sites

Hi mr_vodka,

You are right! I'm looking for the third digit from the decimal point and not only third digit I need to looking up all the digit one by one. Like:

Amount field - 10,567.89

Field 1 - 9

Field 2 - 8

Field 3 - 7

Field 4 - 6

Field 5 - 5

Field 6 - 0

Field 7 - 1

Any Idea? Thank for reply!

Link to comment
Share on other sites

Field 1 - 9

Field 2 - 8

Field 3 - 7

Field 4 - 6

Field 5 - 5

Field 6 - 0

Field 7 - 1

Since you can cut up a repeating field could this be written into a single repeating calc'field:

Mod ( Div ( Round(Extend ( entry );2) ; 10^(Get (CalculationRepetitionNumber )-3) ) ; 10 )

--sd

Link to comment
Share on other sites

This topic is 5784 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.