cancel
Showing results for
Did you mean:
See all
See all
##### Top groups
Explore all groups

## Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user

Level 1: Seed

25 / 150 points

Next: Root

## Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

What goes around comes around! Share the love by gifting kudos to your peers.

## Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

## Come for the products,stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

4,458,136
Community Members

Community Events
176
Community Groups

# Need to find best way to display calculated data within confiform

Hi there

Wondering what is the best way to show calculated data, for instance: the % of FTEs vs contractors resources. Here is what I have in  confiform

name

type —> FTE or CTR

cost

what I want is the following

total FTE, and CTR

And

FTE / total resources (FTE and CTR) = % of FTE

would that be solved by ConfiForms ValueView?

thanks

And yes, the same approach can be used by ValueView, calculating each value individually

Alex

I used table merger and it display like this

Type - Total

CTR -  30

FTE - 10

but how to display at the end or within each row the % of that number

Type - Total - Percentage

CTR - 30 - 75%

FTE - 10 - 25%

thanks

Something like this

`FTE%:([count_type=FTE]*100/[total])`

Hmmm, I haven’t tried this but it doesn’t sound right to me. Would like an explanation please.
I am thinking loud here, Why I need to mention count_type=FTE? It need to be dynamically for that row, no? Also I am assuming [total] means the total of all rows?

My guess the correct formula is ([count_type]*100)/[Total]? Haven’t tried this but the goal to make it dynamic per row. Total is the column in the table merge

please note the data example I gave is simple :) the actual data I have is more than 2 rows. I just didn’t want to show the entire data

is this doable @Alex Medved _ConfiForms_ ? thanks

What is doable? I have suggested a way how to calculate grouped values.
you had doubts and own suggestions  - feel free to use whatever you think is appropriate

thanks for getting back to me but your suggestion is not dynamic and I tried it as well  with Table Merger but it didn't work. Sorry if I misunderstood your suggestion. but I am looking for dynamic result, let me try to make is more clear of what I am looking for:

table Merger:

Type - Total Resources - Percentage

CTRA - 20 - 25%

CTRB - 30 - 37.5 %

FTEA - 20 - 25%

FTEB - 10 - 12.5%

the percentage column need to by dynamic based on left side (Total Resources). Hoping there is a solution something like this: ie: CTRA = (20/80) * 100

what is CTRA --> 20 will be in the formula

what is the entire total resources --> 80 will be in the formula

Thanks for all the help @Alex Medved _ConfiForms_