0

Creating Two NL(ROWS) on the same row in a spreadsheet

Hi

In Cell C21 i have this function: =NL("Rows","FilteredSalesOrder","salesorderid","createdon",NP("DateFilter",StartDate,EndDate))

 

In Cell M21 i have this function: =NL("Rows","FilteredOpportunity","opportunityid","purchasetimeframename","Immediate","statecodename","Open","opportunityratingcodename","A - 90% Banker")

When I run the report the C21 row is repeated for the amount of responses the M21 function returns creating tons of duplicates.

Is it possible to get them to run independently?

Regards

Dave

 

2 comments

Please sign in to leave a comment.