nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Need to find best way to display calculated data within confiform

Markisio

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

Accepted answers

All comments

Alex Medved _ConfiForms_

Have a look at this page https://wiki.vertuna.com/display/CONFIFORMS/Advanced+aggregations+and+calculations+with+TableView+Merger

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

Alex

Markisio

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%

thanks

Alex Medved _ConfiForms_

Something like this

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

Markisio

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_

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

server

confluence-server

confiforms