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; } } }

Maximum and percentage

portosr

Hi all
if I have a table like the following:

Col1 Col2
Hall, 39650
area1, 2784
area2, 5834

How I can get the maximum in the col2?
I need this value as I have to calculate in another column the percentage for example: (MAX-2784)/MAX*100;

Thank
portos

Find more posts tagged with

Comments

mwilliams

Drag an aggregation into your table or go to the binding tab in the property editor and choose the add aggregation button. Then choose the agg function of MAX and choose Col2 for your expression. You could also do this in a computed column in your dataSet if you wanted. Let me know if you have questions.