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

Functions of the Aggregation Builder

Linda_prov

Hi,

I?m looking for an overview of the Functions which are availaible in the listbox of the aggregation builder.
I dont know what most of these funcions calculate. So: what do they mean?
Is there any list or overview availaible?
thx a lot

Linda

Find more posts tagged with

Comments

mwilliams

You might be able to find something to show you this in the documentation. What functions in the list are you unsure of? I'll try to help you with the ones you're unsure of.

Linda_prov

Hi Michael,
thx for answering. I didnt find the explanations in the online help. If you have any link it would be great.
Im not sure about the following functions:

is npv = net present value?
mode = modulo?
Concateonate: What means "Show all values" in this context?
Rank: Does Rank show all values in new order?

thx a lot
Linda

mwilliams

Yes, NPV = Net Present Value

Mode = Value that occurs most times in the field specified

Show All Value = Whether you want to show repeating values in the concatenation string. False would remove repeating values, true would allow them.

Rank will assign a rank value to a row. It won't reorder the dataSet. It would be up to you to sort the dataSet table on the rank field.

Hopefully this helps!

Linda_prov

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="80091" data-time="1310660246" data-date="14 July 2011 - 09:17 AM">
Yes, NPV = Net Present Value 
 
Mode = Value that occurs most times in the field specified 
 
Show All Value = Whether you want to show repeating values in the concatenation string. False would remove repeating values, true would allow them. 
 
Rank will assign a rank value to a row. It won't reorder the dataSet. It would be up to you to sort the dataSet table on the rank field. 
 
Hopefully this helps! </blockquote>
 
Hi Michael, 
 
thx a lot for your help!

mwilliams

Not a problem. Let us know whenever you have questions!