Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hey Sunny ,
Did you find any solution Pal.
Regards
charlie
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?
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
Hey Sunny,
did you understand it .....?
Regards
charlie
HeySunny ,
Any advice on the expression pal...
Regards
Charlie