Forum Discussion
Based on multiple if condition then it should sum the two values.
| version | onboarding plan | app id | No of Feeds | OUTPUT | Modified | |
| 4 | A_0002 | XYZ | 2 | 12 | 2/1/2024 | |
| 3 | A_0002 | XYZ | 2 | 10/1/2023 | ||
| 2 | A_0003 | XYZ | 20 | 3/5/2024 | ||
| 1 | A_0003 | XYZ | 10 | 12 | 2/1/2024 |
For every record in the file
for each onboarding for this application
{if there are any other onboardings for the same application with modified
date less than or equal to the current onboarding version's modified date
(MDC)
THEN add the feed count of the max(modified date) FCO from that set with
current onboarding version's feed count FCC
end-if
When this happens--76 views and counting, with no replies--it generally means none of us is clear on what you're trying to do.
So you could help us help you by
- giving a more complete description of what you're trying to do
- posting a copy of (or facsimile of) your actual spreadsheet on OneDrive or GoogleDrive with a link here that grants access to it.
