How to do use aggregate value?

aishwary2003

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

Screenshot 2024-07-03 121132.png

Accepted answers

All comments

nvilkko

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

rosie101

@slope 3d: Thanks. It worked for me! nvilkko

grammarianbasil

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.

EllaRichards

Thanks! Now I can go back playing agario lol

cirocristhian

@tubidy Thank you sir. It's worked for me!

Ethancarter

@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).

fdghfdh564

@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!

RowanButler

@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.

saadkhan42

Aggregate values help summarize data by grouping and calculating totals, averages, or counts.

MEPCO Bill

They’re essential in databases, spreadsheets, and analytics for efficient data processing and insights

Quick Links

Can you help?

Unanswered questions

Create a Filter to show all the elements of that level based on selection in hierarchy
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…