0

Conditional replication

Annelise Stage

September 19, 2019 20:11

None

Follow

I would like to make rows from either one or another NL-function dependent on an IF-function.

I know that the IF-function need to be inside the NL Row-function, but I can't get it to work. I have read the small article about conditional replication.

I have these two NL-formulas. The first should be activated if the first condition in the IF-function is TRUE and the other one, IF it is FALSE:

1.'NL("rows","Sagsopgave",,"Elsec-status",$F$2,,,"+Sagsnr.",NL("filter","Sag","Nummer","Sagsbogføringsgruppe",$E2;"Spærret","''","Ansvarlig",$F$3)) 

2. 'NL("rows","Sagsopgave",,"Elsec-status",$F$2,"Ansvarlig",$C$3,"+Sagsnr.",NL("filter","Sag","Nummer","Sagsbogføringsgruppe",$E3,"Spærret","''"))

Please note it's "open" Nl-functions - I don't return a field (NF-function to follow). I understand that I should write the Table-name (in this case "Sagsopgave") in the second argument in the IF-function and the { } (always {} and why???) in the third argument.

Anyone know how to solve this? I have tried many different combinations, but with no luck. 

(I know you can't read the field-names in the NL-functions, but I guess that's not important)

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Bryan Robinson September 20, 2019 18:30

  The problem you are having it with regards to the conditional replication article is that you are using different.  The article address the idea that based on a condition, the replicator will or will not run.

  You are trying to use it where based on a condition, the replicator itself is changing which is different.

  My suggestion is to create your Filter Field and Filter values in separate cells that are wrapped in an IF statement, then reference those cells in your Jet function.

  You might need to do something like this with your filters:

  

• 0
  
  Annelise Stage September 22, 2019 19:01

  Hi Bryan,

  Thank you for your answer. 

  Unfortunately I can't figure out, how to get it to work according to your directions. 

  Question: In the IF-function the second argument would be "Country/Region code", which is what should be done if the first argument is true. Then after the comma you write "". When I am wearing my "Jet-reports "hat" I would read it as the Country/Region code should be "blank"/empty. But wearing my excel"hat" I would say that "" is the third argument in the IF-function. How does excel know that all arguments coming after "Country/region code" are Jet-related filterfields and filters? 

  Anyway - I have tried to follow your directions and can't get it to work. I have enclosed a file to show how the fields are connected. They are marked with yellow. The word "Hvis" = IF. Do you see where the problem is?

  Thank you in advance