Set Expression

[#1]

sum(if(vColl='A' and YearMonth = text(Timestamp(Today,'YYYYMM')),L1SBSrcTgtAmount+L2SBSrcTgtAmount,

if(vColl='C' and   YearMonth = text(Timestamp(Today,'YYYYMM')) ,L1SBSrcTgtCount+L2SBSrcTgtCount)))

someone please change in to setanalysis.

thanks In advance

Regards

charlie

[#2]

Hey Alex,

very happy you are trying , y is it not working still, i had attached the sample qvf above , could you please check in it once ..sorry for putting you through trouble Alex.

Regards

charlie

[#3]

Hey Sunny ,

Did you find any solution Pal.

Regards

charlie

[sunny_talwar]

I am confused... look at 1st sheet, but change to set analysis in sheet 2 and 3? Can you elaborate what am I looking at within 1st sheet and why? and which object I am working on in Sheet2 or Sheet3? Why both sheets? what is the difference here?

[#5]

1st sheet its done , i changed some how. it is for ur better understanding  , u have to change the second sheet and 3rd sunny. the one i asked is in 3rd sheet KPI. And there is a variable in all the sheet to view count/Amount. i had attached for ur reference.

Regards

charlie

[#6]

Hey Sunny,

did you understand it .....?

Regards

charlie

[#7]

HeySunny ,

Any advice on the expression pal...

Regards

Charlie