Help me please, please please

[LiveOak]

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

[Vaughan]

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.

[way]

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.

[BobWeaver]

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.

[Vaughan]

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>