Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

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 Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

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


Gift kudos to your peers

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.

Atlassian Community about banner
Community Members
Community Events
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 


type —> FTE or CTR 



what I want is the following 

total FTE, and CTR 


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

would that be solved by ConfiForms ValueView? 



1 answer

Have a look at this page

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


thanks @Alex Medved _ConfiForms_ 


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%



Something like this


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 

thanks @Alex Medved _ConfiForms_ 

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 

HI @Alex Medved _ConfiForms_ 


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_ 

Suggest an answer

Log in or Sign up to answer

Atlassian Community Events