Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

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

Recommended Posts

Posted

I have a repeated field with 80 repetitions, that I am using to create a bar graph for weights. I have a calculation and conditional set so that the bar color is set appropriately based on the weight. Works great, but I want to do one more thing with it and can't figure out how...

When I print the graph, I only want the actual number of repetitions or length of the colored portion to print, followed by the weight appended immediately to the right of the bar. Right now, I have the graph printing and it looks good, but I can't place the weight directly at the end of the bar.

So it would look like this (R=repetition displayed with color):

RRRRRRRRRRRRRRRRRRR 50

RRRRRRRRRRRRRRRRRRRRRRRRRR 70

etc.

The bar field is defined as:

Get ( CalculationRepetitionNumber ) ≤ Extend(Weight)

The conditional sets a repetition to blue if Value = 1

Must be some sort of calculation to do this??

Thanks.

Posted (edited)

Yes, that did it...after I used a substitute in the calculation to change the 0s to spaces!! Thanks.

Edited by Guest
Posted

Try in the file I posted in the original thread - you'll see the substitution isn't necessary.

http://fmforums.com/forum/showtopic.php?tid/209772/

This topic is 5682 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
×
×
  • Create New...

Important Information

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