Forum Discussion

jhaanand81's avatar
jhaanand81
Frequent Visitor
4 years ago
Solved

Subtotal of Negative Values

Hi,   Please help me with subtotal of negative value in single row and adding it with a positive value without splitting the row Amount 27733.51 -6201900.18 6177381.24 -77460.65 96...
Need Help
  • jhaanand81's avatar
    jhaanand81
    4 years ago

    Hi  Nathaniel,

     

    Thank you for your reply please find the details and let me know if you are able to understand my query.

    Yes need to split the single to get the output.

     

    Document DateAmount in doc. curr.Subtotal Positive Values(Amount in doc. curr.)  more than 1 Output 1Total of Value(Amount in doc. curr.) less than 0 Output 2Total of Negative Value(-16197615.03+Subtotal of Positive Value) Output 3
    31-10-202127733.51 -6201900.18-16169881.52
    31-10-2021-6201900.18 -77460.65-9992500.28
    31-10-20216177381.24 -164075.37-9896376.28
    30-09-2021-77460.65 -164075.37-9732154.28
    23-09-202196124 -164075.37-9567932.28
    01-10-2021-164075.37 -107457.97-9403710.28
    24-09-2021164222 -127615.96-9296156.28
    01-10-2021-164075.37 -34430.54-9168426.28
    24-09-2021164222 -153512.81-9133961.28
    01-10-2021-164075.37 -163591.81-8980311.28
    24-09-2021164222 -92810.06-8816573.28
    01-10-2021-107457.97 -298319.41-8723680.28
    24-09-2021107554 -184541.08-8425094.28
    01-10-2021-127615.96 -164510.98-8240388.28
    24-09-2021127730 -127596.97-8075730.28
    04-10-2021-34430.54 -216945.13-7948019.28
    27-09-202134465 -124299.92-7730880.28
    04-10-2021-153512.81 -88004.36-7606469.28
    27-09-2021153650 -125634.73-7518386.28
    04-10-2021-163591.81 -23637.34-7392639.28
    27-09-2021163738 -98490.41-7368978.28
    04-10-2021-92810.06 -64018.92-7270389.28
    27-09-202192893 -171185.02-7206306.28
    04-10-2021-298319.41 -114399.77-7034968.28
    27-09-2021298586 -99440.14-6920466.28
    04-10-2021-184541.08 -119750-6820937.28
    27-09-2021184706 -49491-6701080.28
    04-10-2021-164510.98 -140522-6651539.28
    27-09-2021164658 -113436-6510891.28
    04-10-2021-127596.97 -82038-6397354.28
    27-09-2021127711 -153218.08-6315243.28
    04-10-2021-216945.13 -133116.04-6161888.28
    27-09-2021217139 -49595.68-6028653.28
    04-10-2021-124299.92 -392974.82-5979013.28
    27-09-2021124411 -152298.9-5585687.28
    04-10-2021-88004.36 -132026.02-5433254.28
    27-09-202188083 -148817.01-5301110.28
    04-10-2021-125634.73 -155374.15-5152160.28
    27-09-2021125747 -99440.14-4996647.28
    04-10-2021-23637.34 -166459.24-4897118.28
    27-09-202123661 -102597.31-4730510.28
    05-10-2021-98490.41 -138842.92-4627821.28
    28-09-202198589 -146134.72-4488854.28
    05-10-2021-64018.92 -131258.7-4342573.28
    28-09-202164083 -130762.14-4211197.28
    05-10-2021-171185.02 -75018.96-4080318.28
    28-09-2021171338 -45141.81-4005232.28
    05-10-2021-114399.77 -158252.58-3960045.28
    28-09-2021114502 -176340.41-3801649.28
    05-10-2021-99440.14 -14583.97-3625151.28
    28-09-202199529 -32748.22-3610554.28
    12-10-2021-119750 -3605345.94-3577773.28
    05-10-2021119857  -3397625.28
    12-10-2021-49491  179987.15
    05-10-202149541   
    12-10-2021-140522   
    05-10-2021140648   
    12-10-2021-113436   
    05-10-2021113537   
    12-10-2021-82038   
    05-10-202182111   
    16-10-2021-153218.08   
    08-10-2021153355   
    16-10-2021-133116.04   
    08-10-2021133235   
    16-10-2021-49595.68   
    08-10-202149640   
    18-10-2021-392974.82   
    11-10-2021393326   
    19-10-2021-152298.9   
    12-10-2021152433   
    19-10-2021-132026.02   
    12-10-2021132144   
    20-10-2021-148817.01   
    13-10-2021148950   
    20-10-2021-155374.15   
    13-10-2021155513   
    25-10-2021-99440.14   
    18-10-202199529   
    25-10-2021-166459.24   
    18-10-2021166608   
    25-10-2021-102597.31   
    18-10-2021102689   
    25-10-2021-138842.92   
    18-10-2021138967   
    25-10-2021-146134.72   
    18-10-2021146281   
    27-10-2021-131258.7   
    20-10-2021131376   
    27-10-2021-130762.14   
    20-10-2021130879   
    27-10-2021-75018.96   
    20-10-202175086   
    27-10-2021-45141.81   
    20-10-202145187   
    29-10-2021-158252.58   
    22-10-2021158396   
    29-10-2021-176340.41   
    22-10-2021176498   
    29-10-2021-14583.97   
    22-10-202114597   
    29-10-2021-32748.22   
    22-10-202132781   
    25-10-2021180148   
    31-10-2021-3605345.94   
    31-10-20213577612.43   
    31-10-202124518.94   
    25-10-202195548   
    25-10-2021116893   
    25-10-2021182577   
    26-10-2021281997   
    27-10-2021133627   
    27-10-2021120197   
    27-10-2021151009   
    27-10-202199529   
    27-10-20212762   
    27-10-2021121188   
    27-10-2021172152   
    27-10-2021161734   
    27-10-2021124411   
    27-10-2021156379   
    27-10-202143792   
    28-10-2021141123   
    28-10-2021127334   
    28-10-2021183513   
    28-10-2021298586   
    28-10-2021281997   
    28-10-2021130535   
    28-10-2021111337   
    28-10-202188731   
    29-10-2021225678   
    30-10-202128198   
  • v-yingjl's avatar
    v-yingjl
    4 years ago

    Hi jhaanand81 ,

    Based on your description, you can try this query:

    let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("xZdJduQwCEDvknVKj3k4S17uf42m2rJLsul17/IgX4wG6ufni/GF8CIg/Pr+Infmofj1+33TvIwAE2BgPJWGxQUOkkMHL8gLdBeDYfpXRbyo0nASsJlCE3Ad7AciC1IqIvqfDLioj+yYekzbeMgNdaQ1zDvjcDCyMizCMOZz5AtSmpnMnUBlRRqBT6RUpp0VNNbEnjGumjZMUiAMsCdSmuSGoAzGHNJYKZWGdZ6FqOCAaDwLcWgZEy3XsmOsktZFUwXQtKuefqsNYhcPWooO5CYedORs7QhljqTOjkhrJwJABjeZLk10mUZSYxneeFYqF++i4ar04KbTSmPTL906ICThKmesHVDVzIaoDw3jCn4lSnNGshGVRwwd0CDvFJ+duTMoXDl2bxgUnW/dYkmRGmrSxJJKRyxIu5X082Nanyp5qDeApGSTRkmdKby9L6DUuFpyk2gdYplNcnOIlTuHgqDLXxDONkS7DRaq6s1PEWI1ocyqHcOMaAOkYZiJO6YSkjqsMSNZbXIQq/jFSeky4sgWrkOXs8wcScHco6EaOqOpbGmEuUO4/rKzF3emUiOzeWCvYgT6gJlQ3goZORvoxmjVSwZqw6jqOW/+3b9bdj79uxNoNSbz3NUbUio7J+7OAGnWkMCGqdREa4cjhM6Pfmc40rxjxPA9vzpGjD57arNToy2GPxNaGnZrEXCj66vfGQjPhqlv/j3C7ImUJjortYzks1tXojQx/b31ZpDSmIuK9uYMPo3vjNfE/0zjjXGTcxnujNRr187bkGqNzjMmlxhzLG1Eac4Qt+ETgNKcii82UK7tmfJUsnpdSjSEnzp6J+2kNlNZV1fTtDV/znPk5lltwhnjOn+qu/JzBmzzyqiTvw/iTl43CDQdtHyPq7huQ+oer/UXjdypxlQjrxP8s8LXd67b4uZkLf3GGynptXLXtkAkbuRUvxekkQdf42qVL+feLl9yvw+KahZt5LXbuPn/CJ8zamtfqrPI4/xtspst8e8f", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Document Date" = _t, #"Amount in doc. curr." = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Document Date", type text}, {"Amount in doc. curr.", type number}}),
    #"Changed Type with Locale" = Table.TransformColumnTypes(#"Changed Type", {{"Document Date", type date}}, "en-GB"),
    #"Added Index" = Table.AddIndexColumn(#"Changed Type with Locale", "Index", 1, 1, Int64.Type),
    #"Filtered Rows" = Table.SelectRows(#"Added Index", each [#"Amount in doc. curr."] > 1),
    #"Added Index1" = Table.AddIndexColumn(#"Filtered Rows", "Index.1", 1, 1, Int64.Type),
    #"Merged Queries" = Table.NestedJoin(#"Added Index", {"Index"}, #"Added Index1", {"Index.1"}, "Added Index1", JoinKind.LeftOuter),
    #"Expanded Added Index1" = Table.ExpandTableColumn(#"Merged Queries", "Added Index1", {"Amount in doc. curr."}, {"Added Index1.Amount in doc. curr."}),
    #"Renamed Columns" = Table.RenameColumns(#"Expanded Added Index1",{{"Added Index1.Amount in doc. curr.", "Output1"}}),
    #"Filtered Rows1" = Table.SelectRows(#"Renamed Columns", each [#"Amount in doc. curr."] < 0),
    #"Added Index2" = Table.AddIndexColumn(#"Filtered Rows1", "Index.1", 1, 1, Int64.Type),
    #"Merged Queries1" = Table.NestedJoin(#"Renamed Columns", {"Index"}, #"Added Index2", {"Index.1"}, "Added Index2", JoinKind.LeftOuter),
    #"Expanded Added Index2" = Table.ExpandTableColumn(#"Merged Queries1", "Added Index2", {"Amount in doc. curr."}, {"Added Index2.Amount in doc. curr."}),
    #"Renamed Columns1" = Table.RenameColumns(#"Expanded Added Index2",{{"Added Index2.Amount in doc. curr.", "Ouput2"}}),
    BufferedValues = List.Buffer(#"Renamed Columns1"[Output1]),
    CumulativeTotal = Table.AddColumn(#"Renamed Columns1", "Output3", each -16197615.03 + List.Sum(List.FirstN(BufferedValues,[Index])),type number),
    #"Removed Columns" = Table.RemoveColumns(CumulativeTotal,{"Index"})
in
    #"Removed Columns"

     

    Best Regards,
    Community Support Team _ Yingjie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

jhaanand81's avatar
jhaanand81
Frequent Visitor
4 years ago

Hi  Nathaniel,

 

Thank you for your reply please find the details and let me know if you are able to understand my query.

Yes need to split the single to get the output.

 

Document DateAmount in doc. curr.Subtotal Positive Values(Amount in doc. curr.)  more than 1 Output 1Total of Value(Amount in doc. curr.) less than 0 Output 2Total of Negative Value(-16197615.03+Subtotal of Positive Value) Output 3
31-10-202127733.51 -6201900.18-16169881.52
31-10-2021-6201900.18 -77460.65-9992500.28
31-10-20216177381.24 -164075.37-9896376.28
30-09-2021-77460.65 -164075.37-9732154.28
23-09-202196124 -164075.37-9567932.28
01-10-2021-164075.37 -107457.97-9403710.28
24-09-2021164222 -127615.96-9296156.28
01-10-2021-164075.37 -34430.54-9168426.28
24-09-2021164222 -153512.81-9133961.28
01-10-2021-164075.37 -163591.81-8980311.28
24-09-2021164222 -92810.06-8816573.28
01-10-2021-107457.97 -298319.41-8723680.28
24-09-2021107554 -184541.08-8425094.28
01-10-2021-127615.96 -164510.98-8240388.28
24-09-2021127730 -127596.97-8075730.28
04-10-2021-34430.54 -216945.13-7948019.28
27-09-202134465 -124299.92-7730880.28
04-10-2021-153512.81 -88004.36-7606469.28
27-09-2021153650 -125634.73-7518386.28
04-10-2021-163591.81 -23637.34-7392639.28
27-09-2021163738 -98490.41-7368978.28
04-10-2021-92810.06 -64018.92-7270389.28
27-09-202192893 -171185.02-7206306.28
04-10-2021-298319.41 -114399.77-7034968.28
27-09-2021298586 -99440.14-6920466.28
04-10-2021-184541.08 -119750-6820937.28
27-09-2021184706 -49491-6701080.28
04-10-2021-164510.98 -140522-6651539.28
27-09-2021164658 -113436-6510891.28
04-10-2021-127596.97 -82038-6397354.28
27-09-2021127711 -153218.08-6315243.28
04-10-2021-216945.13 -133116.04-6161888.28
27-09-2021217139 -49595.68-6028653.28
04-10-2021-124299.92 -392974.82-5979013.28
27-09-2021124411 -152298.9-5585687.28
04-10-2021-88004.36 -132026.02-5433254.28
27-09-202188083 -148817.01-5301110.28
04-10-2021-125634.73 -155374.15-5152160.28
27-09-2021125747 -99440.14-4996647.28
04-10-2021-23637.34 -166459.24-4897118.28
27-09-202123661 -102597.31-4730510.28
05-10-2021-98490.41 -138842.92-4627821.28
28-09-202198589 -146134.72-4488854.28
05-10-2021-64018.92 -131258.7-4342573.28
28-09-202164083 -130762.14-4211197.28
05-10-2021-171185.02 -75018.96-4080318.28
28-09-2021171338 -45141.81-4005232.28
05-10-2021-114399.77 -158252.58-3960045.28
28-09-2021114502 -176340.41-3801649.28
05-10-2021-99440.14 -14583.97-3625151.28
28-09-202199529 -32748.22-3610554.28
12-10-2021-119750 -3605345.94-3577773.28
05-10-2021119857  -3397625.28
12-10-2021-49491  179987.15
05-10-202149541   
12-10-2021-140522   
05-10-2021140648   
12-10-2021-113436   
05-10-2021113537   
12-10-2021-82038   
05-10-202182111   
16-10-2021-153218.08   
08-10-2021153355   
16-10-2021-133116.04   
08-10-2021133235   
16-10-2021-49595.68   
08-10-202149640   
18-10-2021-392974.82   
11-10-2021393326   
19-10-2021-152298.9   
12-10-2021152433   
19-10-2021-132026.02   
12-10-2021132144   
20-10-2021-148817.01   
13-10-2021148950   
20-10-2021-155374.15   
13-10-2021155513   
25-10-2021-99440.14   
18-10-202199529   
25-10-2021-166459.24   
18-10-2021166608   
25-10-2021-102597.31   
18-10-2021102689   
25-10-2021-138842.92   
18-10-2021138967   
25-10-2021-146134.72   
18-10-2021146281   
27-10-2021-131258.7   
20-10-2021131376   
27-10-2021-130762.14   
20-10-2021130879   
27-10-2021-75018.96   
20-10-202175086   
27-10-2021-45141.81   
20-10-202145187   
29-10-2021-158252.58   
22-10-2021158396   
29-10-2021-176340.41   
22-10-2021176498   
29-10-2021-14583.97   
22-10-202114597   
29-10-2021-32748.22   
22-10-202132781   
25-10-2021180148   
31-10-2021-3605345.94   
31-10-20213577612.43   
31-10-202124518.94   
25-10-202195548   
25-10-2021116893   
25-10-2021182577   
26-10-2021281997   
27-10-2021133627   
27-10-2021120197   
27-10-2021151009   
27-10-202199529   
27-10-20212762   
27-10-2021121188   
27-10-2021172152   
27-10-2021161734   
27-10-2021124411   
27-10-2021156379   
27-10-202143792   
28-10-2021141123   
28-10-2021127334   
28-10-2021183513   
28-10-2021298586   
28-10-2021281997   
28-10-2021130535   
28-10-2021111337   
28-10-202188731   
29-10-2021225678   
30-10-202128198   
  • v-yingjl's avatar
    v-yingjl
    Community Support
    4 years ago

    Hi jhaanand81 ,

    Based on your description, you can try this query:

    let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("xZdJduQwCEDvknVKj3k4S17uf42m2rJLsul17/IgX4wG6ufni/GF8CIg/Pr+Infmofj1+33TvIwAE2BgPJWGxQUOkkMHL8gLdBeDYfpXRbyo0nASsJlCE3Ad7AciC1IqIvqfDLioj+yYekzbeMgNdaQ1zDvjcDCyMizCMOZz5AtSmpnMnUBlRRqBT6RUpp0VNNbEnjGumjZMUiAMsCdSmuSGoAzGHNJYKZWGdZ6FqOCAaDwLcWgZEy3XsmOsktZFUwXQtKuefqsNYhcPWooO5CYedORs7QhljqTOjkhrJwJABjeZLk10mUZSYxneeFYqF++i4ar04KbTSmPTL906ICThKmesHVDVzIaoDw3jCn4lSnNGshGVRwwd0CDvFJ+duTMoXDl2bxgUnW/dYkmRGmrSxJJKRyxIu5X082Nanyp5qDeApGSTRkmdKby9L6DUuFpyk2gdYplNcnOIlTuHgqDLXxDONkS7DRaq6s1PEWI1ocyqHcOMaAOkYZiJO6YSkjqsMSNZbXIQq/jFSeky4sgWrkOXs8wcScHco6EaOqOpbGmEuUO4/rKzF3emUiOzeWCvYgT6gJlQ3goZORvoxmjVSwZqw6jqOW/+3b9bdj79uxNoNSbz3NUbUio7J+7OAGnWkMCGqdREa4cjhM6Pfmc40rxjxPA9vzpGjD57arNToy2GPxNaGnZrEXCj66vfGQjPhqlv/j3C7ImUJjortYzks1tXojQx/b31ZpDSmIuK9uYMPo3vjNfE/0zjjXGTcxnujNRr187bkGqNzjMmlxhzLG1Eac4Qt+ETgNKcii82UK7tmfJUsnpdSjSEnzp6J+2kNlNZV1fTtDV/znPk5lltwhnjOn+qu/JzBmzzyqiTvw/iTl43CDQdtHyPq7huQ+oer/UXjdypxlQjrxP8s8LXd67b4uZkLf3GGynptXLXtkAkbuRUvxekkQdf42qVL+feLl9yvw+KahZt5LXbuPn/CJ8zamtfqrPI4/xtspst8e8f", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Document Date" = _t, #"Amount in doc. curr." = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Document Date", type text}, {"Amount in doc. curr.", type number}}),
    #"Changed Type with Locale" = Table.TransformColumnTypes(#"Changed Type", {{"Document Date", type date}}, "en-GB"),
    #"Added Index" = Table.AddIndexColumn(#"Changed Type with Locale", "Index", 1, 1, Int64.Type),
    #"Filtered Rows" = Table.SelectRows(#"Added Index", each [#"Amount in doc. curr."] > 1),
    #"Added Index1" = Table.AddIndexColumn(#"Filtered Rows", "Index.1", 1, 1, Int64.Type),
    #"Merged Queries" = Table.NestedJoin(#"Added Index", {"Index"}, #"Added Index1", {"Index.1"}, "Added Index1", JoinKind.LeftOuter),
    #"Expanded Added Index1" = Table.ExpandTableColumn(#"Merged Queries", "Added Index1", {"Amount in doc. curr."}, {"Added Index1.Amount in doc. curr."}),
    #"Renamed Columns" = Table.RenameColumns(#"Expanded Added Index1",{{"Added Index1.Amount in doc. curr.", "Output1"}}),
    #"Filtered Rows1" = Table.SelectRows(#"Renamed Columns", each [#"Amount in doc. curr."] < 0),
    #"Added Index2" = Table.AddIndexColumn(#"Filtered Rows1", "Index.1", 1, 1, Int64.Type),
    #"Merged Queries1" = Table.NestedJoin(#"Renamed Columns", {"Index"}, #"Added Index2", {"Index.1"}, "Added Index2", JoinKind.LeftOuter),
    #"Expanded Added Index2" = Table.ExpandTableColumn(#"Merged Queries1", "Added Index2", {"Amount in doc. curr."}, {"Added Index2.Amount in doc. curr."}),
    #"Renamed Columns1" = Table.RenameColumns(#"Expanded Added Index2",{{"Added Index2.Amount in doc. curr.", "Ouput2"}}),
    BufferedValues = List.Buffer(#"Renamed Columns1"[Output1]),
    CumulativeTotal = Table.AddColumn(#"Renamed Columns1", "Output3", each -16197615.03 + List.Sum(List.FirstN(BufferedValues,[Index])),type number),
    #"Removed Columns" = Table.RemoveColumns(CumulativeTotal,{"Index"})
in
    #"Removed Columns"

     

    Best Regards,
    Community Support Team _ Yingjie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • jhaanand81's avatar
      jhaanand81
      Frequent Visitor
      4 years ago

      Hi, Yingil,

       

      Please help with the same output 1,2,3 with the below data set:

       

      AccountDocument NumberDocument DateAmount in doc. curr.
      IN00001950650017316608-09-202111,79,677.00
      IN00001950650017381408-09-20212,56,564.00
      IN00001950650017490610-09-202113,35,889.00
      IN00001950650017616012-09-202111,17,600.00
      IN00001950650017619510-09-202112,51,291.00
      IN00001950650017677212-09-202167,517.00
      IN00001950650017678413-09-202110,01,480.00
      IN00001950650017678513-09-20215,03,902.00
      IN00001950650017697814-09-202115,93,720.00
      IN00001950650017790215-09-20214,45,705.00
      IN00001950650017790815-09-202111,13,140.00
      IN00001950650017886716-09-202119,30,226.00
      IN00001950650017950316-09-202141,517.00
      IN00001950650018123918-09-202115,77,427.00
      IN00001950650018124018-09-202114,67,081.00
      IN00001950650018124118-09-202110,14,993.00
      IN00001950650018124218-09-20214,21,663.00
      IN00001950650018226420-09-202114,32,321.00
      IN00001950650018226520-09-202112,89,969.00
      IN00001950650018233721-09-202115,35,120.00
      IN00001950650018243421-09-20219,96,713.00
      IN00001950650018243521-09-20218,14,891.00
      IN00001950650018313821-09-20212,31,638.00
      IN00001950650018313921-09-202143,247.00
      IN00001950650019279204-10-20217,65,191.00
      IN00001950650019279304-10-20217,39,727.00
      IN00001950650019281705-10-202110,75,197.00
      IN00001950650019284305-10-202116,16,259.00
      IN00001950650019347305-10-202113,92,459.00
      IN00001950650019370206-10-202114,88,516.00
      IN00001950650019433706-10-202117,15,166.00
      IN00001950650019433806-10-202155,589.00
      IN00001950650019595409-10-20218,50,445.00
      IN00001950650019595509-10-20211,60,135.00
      IN00001950650019596409-10-20215,39,357.00
      IN00001950650019633309-10-20212,925.00
      IN00001950650019634409-10-20219,87,324.00
      IN00001950650019648409-10-202118,55,928.00
      IN00001950650019704910-10-202115,46,766.00
      IN00001950650019801611-10-20219,03,227.00
      IN00001950650019824312-10-202117,39,031.00
      IN00001950650019824412-10-202113,31,305.00
      IN00001950650019866212-10-20211,98,500.00
      IN00001950650019927412-10-202110,802.00
      IN00001950650019952914-10-20219,82,355.00
      IN00001950650019959614-10-20214,00,099.00
      IN00001950650020098816-10-20212,79,669.00
      IN00001950650020099316-10-202117,26,621.00
      IN00001950650020099416-10-202110,42,559.00
      IN00001950650020138018-10-202157,017.00
      IN00001950650020450218-10-202121,07,730.00
      IN00001950650020654722-10-202114,14,677.00
      IN00001950650020654822-10-20211,66,489.00
      IN00001950650020690923-10-202112,91,987.00
      IN00001950650020731823-10-202120,12,481.00
      IN00001950650021090627-10-202116,60,816.00
      IN00001950650021143128-10-202110,92,960.00
      IN00001950650021143228-10-20213,70,286.00
      IN00001950650021143428-10-20212,30,072.00
      IN00001950650021167928-10-20214,25,172.00
      IN00001950650021169628-10-202112,36,244.00
      IN00001950650021404401-11-202110,44,343.00
      IN00001950650021405702-11-202112,91,322.00
      IN00001950650021408802-11-202112,93,276.00
      IN00001950650021409002-11-202116,97,788.00
      IN00001950650021409102-11-20212,03,648.00
      IN00001950650021432702-11-202112,81,387.00
      IN00001950650021504804-11-20215,56,639.00
      IN00001950650021504904-11-20218,36,231.00
      IN00001950650021505205-11-202111,97,991.00
      IN00001950650021731308-11-202113,95,994.00
      IN00001950650021755609-11-202119,29,327.00
      IN00001950650021755709-11-20211,70,463.00
      IN00001950650021808509-11-20219,90,247.00
      IN00001950650021808609-11-202110,50,344.00
      IN00001950650021808709-11-20214,81,837.00
      IN00001950650021812209-11-20211,45,516.00
      IN00001950650021862810-11-20212,59,479.00
      IN00001950650021931711-11-202118,07,971.00
      IN00001950650021934311-11-202113,30,086.00
      IN00001950650021958110-11-202113,54,193.00
      IN00001950650022026711-11-202111,48,745.00
      IN00001950650022026811-11-20214,08,187.00
      IN00001950650022140413-11-202114,12,799.00
      IN00001950650022140513-11-20213,58,445.00
      IN00001950650022180913-11-202112,80,376.00
      IN00001950650022225413-11-202112,09,988.00
      IN00001950650022225513-11-202115,45,646.00
      IN00001950650022225613-11-20214,17,431.00
      IN00001950650022248914-11-20212,92,452.00
      IN00001950650022252414-11-202113,16,386.00
      IN00001950650022350215-11-202115,15,663.00
      IN00001950650022350315-11-20216,35,743.00
      IN00001950650022368516-11-202115,73,653.00
      IN00001950650022379816-11-202117,15,579.00
      IN00001950650022462617-11-202111,44,859.00
      IN00001950650022464417-11-202111,13,279.00
      IN00001950650022563818-11-202114,29,688.00
      IN00001950650022564518-11-202112,77,593.00
      IN00001950650022564618-11-20212,05,551.00
      IN00001950650022564718-11-202117,966.00
      IN00001950650022575418-11-202114,31,088.00
      IN00001950650022779419-11-202113,92,590.00
      IN00001950650022780019-11-202114,49,994.00
      IN00001950650022899521-11-20218,35,413.00
      IN00001950650022899821-11-20218,87,775.00
      IN00001950650022899921-11-20212,22,172.00
      IN00001950650022907720-11-202117,41,122.00
      IN00001950650023050023-11-202113,70,348.00
      IN00001950650023051623-11-202110,36,759.00
      IN00001950650023360025-11-20217,09,524.00
      IN00001950650023360525-11-20216,32,756.00
      IN00001950650023796330-11-202115,42,508.00
      IN00001950430015554601-10-2021-14,34,958.00
      IN00001950430015576613-10-2021-36,18,261.00
      IN00001950430016987015-11-2021-48,81,276.00
      IN00001950430015555211-10-2021-30,11,346.00
      IN00001950430015555008-10-2021-19,69,982.00
      IN00001950430016894201-11-2021-59,37,358.00
      IN00001950430015554704-10-2021-37,68,928.00
      IN00001950430016913508-11-2021-30,46,125.00
      IN00001950110000784230-09-2021-2,18,491.98
      IN00001950430017283019-11-2021-33,51,701.00
      IN00001950430016501126-10-2021-15,03,495.00
      IN00001950430015554805-10-2021-15,03,984.00
      IN00001950430015557012-10-2021-27,19,860.00
      IN00001950430016923309-11-2021-21,62,810.00
      IN00001950430016894605-11-2021-13,81,218.00
      IN00001950430016894302-11-2021-41,79,131.00
      IN00001950430016501827-10-2021-40,80,272.00
      IN00001950430016500320-10-2021-14,65,771.00
      IN00001950430017047917-11-2021-16,59,332.00
      IN00001950430016502728-10-2021-32,56,360.00
      IN00001950430015554907-10-2021-31,49,751.00
      IN00001950  5,34,24,123.02
      IN00001950  5,34,24,123.02
      IN00004576650019598108-10-202168,449.00
      IN00004576650019676208-10-202118,139.00
      IN00004576650020054816-10-202146,610.00
      IN00004576650020115816-10-202157,550.00
      IN00004576650021147328-10-202120,056.00
      IN00004576650021186728-10-202182,108.00
      IN00004576650021209829-10-202111,211.00
      IN00004576650021890310-11-202124,141.00
      IN00004576650021937110-11-202165,128.00
      IN00004576650023309125-11-202177,779.00
      IN00004576650023309225-11-202123,946.00
      IN00004576430016115526-10-2021-1,00,000.00
      IN00004576430017292020-11-2021-1,00,000.00
      IN00004576430015589716-10-2021-1,00,000.00
      IN00004576430016942210-11-2021-1,00,000.00
      IN00004576430015488707-10-2021-1,00,000.00
      IN00004576100008220030-09-2021422.00
      IN00004576110000807730-09-2021-7,416.00
      IN00004576  -11,877.00
      IN00004576  -11,877.00
         5,34,12,246.02