How to do use aggregate value?
Hey everyone,
i am stuck at the part where i have to devise a formula for Subtract 1 line item,for that i need the extra value which is 5% in this case ,can be seen in Override-Allocation line item and i need to divide it in those members which do not overriden the values like for LM1,LM2,LM3,LM4 and LM5 which looks like 1.25% for LM1,LM3,LM4,LM5 each and 0% for LM2.So for that i have a count line item which adds upto 4 which when divide 5% extra result in 1.25% but for to put this in a formula.
Check attached screenshot
Answers
-
Hi @aishwary2003,
I am assuming MLM1 is the parent of these LM items.
- You need a line item where you check the items where the extra result (1.25%) should be applied. Based on your screenshot this could be NOT 'Override?' or 'Count 1' <> 0.
- If I understand correctly, what you want to do is, divide the parent summary (MLM 1) of 'Override-Allocation' with the parent summary of 'Count 1'. You can reference the parent summary by looking up the parent of LM items. You should have a properties module for LM list where you have a line item for the parent. You can use that for the lookup.
- Final Formula: IF Extra Result? THEN 'Override-Allocation'[LOOKUP: Parent] / 'Count 1'[LOOKUP: Parent] ELSE 0
Hope this helps!
Niko
1 -
geometry dash If you need to apply this in a context where some line items receive the extra percentage and others don’t, you might use conditional logic to determine which items get the allocation.
0 -
Thanks! Now I can go back playing agario lol
0 -
@tubidy Thank you sir. It's worked for me!
0 -
@Snow Road You can use your count line item to find out how many members are eligible for the distribution. From your description, this count is 4 (LM1, LM3, LM4, LM5).
0 -
@ragdoll hit Hey!
To distribute the 5%, use:
IF Override-Allocation = 0 THEN Extra Value / Count Line Item ELSE 0.
This splits the 5% (e.g., 1.25% each for 4 members) while assigning 0% to overridden ones. Hope this helps!0 -
@a little to the left For the members LM1, LM3, LM4, and LM5, each will receive 1.25%, and LM2 will have 0%. Ensure the count line item correctly reflects the number of members (excluding LM2), and then distribute the extra value based on the count.
0 -
Aggregate values help summarize data by grouping and calculating totals, averages, or counts.
They’re essential in databases, spreadsheets, and analytics for efficient data processing and insights
0
