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
There was an error rendering this rich post.
Hi all, The Client ID and Client Secret are available, intended for uploading and downloading files. Could anyone advise how to use these credentials DIRECTLY to make API requests? Thank you!
I have A6 as the parent list and two sibling lists: A6.5 and A7. The A7 list includes an attribute that maps to A6.5. In the UX, the user will select A6.5 using a content selector, and the grid (dimensioned by A7) should display only the A7 items associated with that selected A6.5. Since the selector is a page context and…
