I'm trying "If StartsWith(JSON_Name,'data.rows.0') Then [Row-1:Counter]+1 Else[Row-1:Counter] EndIf" into Mmulti-Row formula tool to get the desired output (attached screenshot), but not sure what I'm doing wrong and getting something else.
I want to use a counter whenever there is a change - like; 'data.rows.0' to 'data.rows.1' and likewise
Please review my logic and help me to get the right solutions. Thanks
Solved! Go to Solution.
Thank you @ShankerV Its working for me. :)
User | Count |
---|---|
107 | |
82 | |
70 | |
54 | |
40 |