Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I'm using comparative analysis and thus created an alternate state called Group 1
my expression as as follows:
sum({[Group 1]<QC_THEME=$::QC_THEME, STEP_DURATION_MIN={'>0'},RECORD_TYPE={'duration'},TPK=$::TPK,STEP_PHASE=$::STEP_PHASE,JOB_ID=$::JOB_ID>}STEP_DURATION_MIN)
now it gives null but if I remove QC_THEME=$::QC_THEME it gives the correct value
please advise
Hi Ali,
maybe because you have an expression like A<B=C in your set_expression? Does that work when you test it in a textbox or so? I don't really understand what that >> $:: << means, but in my experience, expressions with two operators are always tricky. Can you pull that apart into two expressions?
HTH
is it because QC_Theme is null for some records?