set analysis(using an if statement)

[#1]

Hi,

Can some1 help me on this, my if statement seems to not be working

(Sum( {$<ScriptMonth={$(=concat('"' & CurrYearMonth & '"', ',' ))}>} if(vMeasures = 'SepPack','(Qty * SepPack)',$(vMeasures))))

if the measure is = 'SepPack' then the calculation is not correct

Thanks in Advance

[alexandros17]

Try with the $ expansion:

(Sum( {$<ScriptMonth={$(=concat('"' & CurrYearMonth & '"', ',' ))}>} if($(vMeasures) = 'SepPack','(Qty * SepPack)',$(vMeasures))))

let me know

[#3]

I tried with that but it still doesnt work

[swuehl · Accepted solution]

Remove the single quotes around your THEN branch:

Sum(

{$<ScriptMonth={$(=concat('"' & CurrYearMonth & '"', ',' ))}>}

     if(vMeasures = 'SepPack',

          (Qty * SepPack)                // removed single quotes here, you want the fields, not a literal

          ,$(vMeasures)    

     )

)

[#5]

Hi,

I removed single quotes  and its working, thanks