I cannot understand why this is not working
Trying to achieve a Purchase Line SUM of amount for Account No. based on Invoice Status
NL("Sum","Purchase Line","Amount","DataSource=","[datasource]","Company=",[company],"Dimension1",[dimension1 code],"Dimension2",[dimension2 code],"No.",[G/L Account No.],"Document No.",NL("Filter","Purchase Header","No.","Status","Released"))
This appears to be the same as previous topics, but not working. I have tried Link= too!
Forgot to say, the Sum works fine before the filtering! The formula has no error, but does not give the right answer. Just comes in at nil - should be 50,000
Have you run the report or are you just looking at the preview value in Design mode? Link= and NL("Filter") do not evaluate until you run the report therefore, you could easily see the wrong answer in Design mode.
Outside of that, if you run it and still get the wrong answer, my guess is that the NL(Filter) is not returning any values. You could confirm by putting the NL(Filter) in a separate cell in Excel and change Filter to Rows. This will let you know if it is returning something or not.
