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 -
Use the final formula you provided to calculate the desired result.
you can learn at papa's scooperia
0