If line item is list formatted and if list item choosen is repeating , then how to get the last ocurrence of every list item?
Input Module
Calculation
Note: Summary for this line item is kept as "last non-blank"
The last occurence is indicated in the summary row.
Thanks
Arun
@PujithaB
Can you please post some snapshots of what are you trying to achieve. We don't have native ISLASTOCCURENCE functionality , the closest we have is LastNonBlank - as an aggregation functionality and you can also change the summary settings of a line item to Last Non Blank - Explore these options and see if this helps
If not, feel free to post a snip here about the expected outcome - will surely try to help
Thanks,
Misbah
Hi, @PujithaB
I suppose that you mean like this, don't you?
I set three modules.
1. Choose from List
-- dimension: numbered list (#1-20), Line item 'Choice' formatted as the List Item Choice(A-D)
2. Process
-- dimension: numbered list(#1-20) & Choice(A-D)
Line Item 'Which' is described below
numbered list has build-in top level and its summary method set as 'Lastnonblank'
3. What is the last row
-- dimension: Choice(A-D)
Line Item 'the last row' = process.which
I hope this works in your model.
Regards,
Taichi
Hi all, I am importing a flat file into ADO. However the flat file does not have a unique identifier. I would like to use the row count as the "ID" Is there a way to create this ADO?
Good morning everyone. I need to build a module export with some specific requirements: users can select a currency type (USD/Local), Salary Type (1 or 2), Nomina Type (1 or 2), and Version (Forecast, TS, Plan). Currently, each of these filters is driven by an independent system module published in the NUX, each…
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
