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

## Recommended Posts

I understood you up until you said "I want to have an resume similar this". (I'm guessing English is not your first language.) Do you mean "result similar to this"?

Then I'm really confused. What to you mean by

"Total of 2 is 1"

Why don't you describe in words what you are trying to do (the overall concept). -bd

##### Share on other sites

It sounds like you want to work out what power of 2 the input number is: 2^2 is 4, or 4 is 2 to the power 2, etc. You need a calculation that works out the base2logarithm of the input number.

FMP has the log() function but this is base 10. To convert the result to base 2 you divide the base 10 result by log(2), thus...

Log(inputfield) / Log(2)

You don't need a dozen other fields for this to work, just the input field and the calculation field above.

##### Share on other sites

• Newbies

I have 5 calculated fields and an numerical. Numerical field have to be given by user(inputfield). Five calculated fields are calculated in this mode: field1=inputfield/2; field2=field1/2; field3=field2/2; field4=field3/2; field5=field4/2.

For example:

With this 3 record in a database:

inputfield; field1; field2; field3; field4; field5

64; 32; 16; 8; 4; 2;

128; 64; 32; 16; 8; 4;

256; 128; 64; 32; 16; 8;

I wanna to have an resume similar this:

Total of 2 is 1

Total of 4 is 2

Total of 8 is 3

Total of 16 is 3

Total of 32 is 3

Total of 64 is 2

Total of 128 is 1

Is this possible in FileMaker for MacOs. (P.S. I'm sure this is possible but I don't know how). Thanks anybody can help me.

##### Share on other sites

I think what Way is saying is:

Total no of records having a field containing 2 is 1

Total no of records having a field containing 4 is 2

Total no of records having a field containing 8 is 3

Total no of records having a field containing 16 is 3

Total no of records having a field containing 32 is 3

Total no of records having a field containing 64 is 2

Total no of records having a field containing 128 is 1

But the real question is, why? It looks like you are trying to use a very difficult technique to do something that's probably fairly simple. Please explain what it is that you are trying to do.

##### Share on other sites

Don't you just *hate* it whan a good, meaty issue klike this goes answered? Come on, were losing sleep over this one!

It's like "Ta Dah" without the "Dah". Was it Oscar Wilde who said: "The anticipation is killling me. I only hope it lasts forever." <g>

##### Share on other sites

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

## Create an account

Register a new account