# Help with Calculation Logic for Labels In Report

**URL:** <https://community.fibery.io/t/help-with-calculation-logic-for-labels-in-report/5673>\
**Category:** Get Help\
**Created:** [January 11, 2024, 12:15am UTC](https://community.fibery.io/t/help-with-calculation-logic-for-labels-in-report/5673 "2024-01-11T00:15:02Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![interr0bangr](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/interr0bangr/32/8089_2.png) [@interr0bangr](https://community.fibery.io/u/interr0bangr)\
**Post date:** [January 11, 2024, 12:15am UTC](https://community.fibery.io/t/help-with-calculation-logic-for-labels-in-report/5673/1 "2024-01-11T00:15:02Z")

</div>

When looking at Charts in an entity view, the legend is hidden behind a click. I’d like to add labels to a chart, so they get displayed under each x-axis value and our users won’t need to click on the legend anymore!

I can’t figure out how to do that on this report, because I’m using the same data field (Points) to generate 3 different numbers (Points Logged, Remaining Capacity & Points Over Capacity) and because the values are always different for each team member (User), there’s no consistent way to accurately label them.

I admit that I find the reporting tool very overwhelming, so maybe there’s something obvious to more power users that I just haven’t thought of and I’d appreciate any help!

 ![Points-Report-Fibery (1)](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/7/7079f34fed28889f4934ae5657bbbb679ce135bc.jpeg)

My calculation for “Points Logged”:

```auto
IF(
	SUMIF(
		[Points],
		[Type] == 'Point Log'
	) > SUMIF(
		[Points],
		[Type] == 'Point Capacity'
	),
	SUMIF(
		[Points],
		[Type] == 'Point Capacity'
	),
	SUMIF(
		[Points],
		[Type] == 'Point Log'
	)
)

```

My calculation for “Remaining Capacity”:

```auto
IF(
	SUMIF(
		[Points],
		[Type] == 'Point Capacity'
	) >= SUMIF(
		[Points],
		[Type] == 'Point Log'
	),
	SUMIF(
		[Points],
		[Type] == 'Point Capacity'
	) - SUMIF(
		[Points],
		[Type] == 'Point Log'
	),
	0
)

```

My calculation for “Points Over Capacity”:

```auto
IF(
	SUMIF(
		[Points],
		[Type] == 'Point Capacity'
	) < SUMIF(
		[Points],
		[Type] == 'Point Log'
	),
	SUMIF(
		[Points],
		[Type] == 'Point Log'
	) - SUMIF(
		[Points],
		[Type] == 'Point Capacity'
	),
	0
)

```

---

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [January 11, 2024, 7:13am UTC](https://community.fibery.io/t/help-with-calculation-logic-for-labels-in-report/5673/2 "2024-01-11T07:13:10Z")

</div>

Can’t you just copy whatever you have used in the box for Color, into the box for Label?

---

<div class="post-metadata">

**Author:** ![interr0bangr](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/interr0bangr/32/8089_2.png) [@interr0bangr](https://community.fibery.io/u/interr0bangr)\
**Post date:** [January 11, 2024, 6:56pm UTC](https://community.fibery.io/t/help-with-calculation-logic-for-labels-in-report/5673/3 "2024-01-11T18:56:05Z")

</div>

I wish it was that easy!

The values for the colors were automatically generated by Fibery and, at least from what I can tell, the formulas don’t get exposed on the front end.

I also can’t drag and drop the colors into the labels section as any attempt to click on those boxes just makes the color changer pop-up

Is there any way to reference the labels of the fields in an axis inside of other calculations?

---

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [January 11, 2024, 7:11pm UTC](https://community.fibery.io/t/help-with-calculation-logic-for-labels-in-report/5673/4 "2024-01-11T19:11:12Z")

</div>

Oh I see.  
Then in that case, I’m not sure it’s possible.  
Seems like the solution would be to make the legend visible on the embedded report.