Hello - I am building a dataset for a capex monthl...
# suiteanalytics
l
Hello - I am building a dataset for a capex monthly report. I have what I need on the dataset but I am getting duplicate rows. I have watched the videos on duplications and made some changes but I am still receiving duplicate line items. I need a report of bills paid during the month that is have a capex GL code or that the item expense category is CAPEX. Any suggestions? Is there a formula I can use to look at the bill number and the transaction line number to eliminate the duplicate? Any help is appreciated.