I have a table following table.
|Report Amt |Report ID |Attendee Name|
|948.14 |20835122 |AJ|
|948.14 |20835122 |BJ|
|948.14 |20835122 |CJ|
|948.14 |20835122 |DJ|
|948.14 |20835122 |EJ|
I need to count Report ID frequency and enter that number in a new column (say “Frequency”). Then use divide Report Amount by Frequency to come up with amount for each attendee.
any guidance is appreciated.
just to see if I got it right. So amount for each attendee is 948,18 / 5 = 189,636.
Couple of questions: Report Amt is same per Report ID, right? You have multiple Report IDs in your data set? Attendee Name is unique per Report ID?
If I got it right you can use Group Loop Start node followed by Math Formula node with syntax:
Report Amt / $$ROWCOUNT$$
Close it with a Loop End and that should do the trick
Try it out and if any problems I can make an example workflow.
Thanks for looking at my issue.
Indeed, it is 948,18 / 5 = 189,636.
Yes, Report Amts align with each Report ID.
Yes, there are multiple attendees for one report id.
Hope that helps.
here is a workflow example:
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.