Trying to add the values in "1 column" with respect to the another column on conditions


I am trying to add only those values in the column Amount in local currency where the Clearing date column is Blank or the month is current month. Please check the screenshots below.

I have added the .xlsx and .xaml files for better understanding. Please guide me on this issue.

ABC (PTY) LTD.xlsx (81.7 KB) SAP_AP Calculation.xaml (66.4 KB)

Please guide me regarding this query. Thank You all in advance.

1 Like

Issue resolved.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.