How to enter a conditional "Where" clause in the below Script?I would like to make two Tabulate tables instead of one Tabulate table. I'd like one Tabulate table for :Prog = "A" and one for :Prog = "B". The script below gives me one Tabulate table with both Programs "A" and "B" in the Tabulate table. I think if I was to break this up into two lines of script; one line being . . . where :Prog = "A" and the other line of identical script except for . . . where :Prog = "B" would do the trick I just don't know where or how to insert the "where" clause.
Tabulate( Add Table( Row Table( Grouping Columns( :Prog, :Matl_Desc ) ) ) );
ScriptingRe: How to enter a conditional "Where" clause in the below Script?Tabulate( Add Table( Row Table( Grouping Columns( :Prog, :Matl_Desc ) ) ),
where(:Prog == "A") );
You may want to look into using the Page feature in Tabulate, it will create a separate table for each level of Prog
