Hi,
I have a question re the order of using nested if's in PQ,
I want to make 'numbers" = 1000 and text strings thant start with 'a' = "AAA , if first tried this,
Does not work;
The first if does but I get an error for numbers, so I changed the order and this worksPlease Login or Register to view this content.
Works;
I can't see why they outcome should differ? I have tried by putting an if to text if it is text before taking the first value but still no good,Please Login or Register to view this content.
Can someone point out the evaluation order ?Please Login or Register to view this content.
Richard.
Bookmarks