Jump to content

Help me please, please please


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

Link to comment
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.

Link to comment
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.

Link to comment
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.

Link to comment
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>

Link to comment
Share on other sites

This topic is 8041 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.