Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Please See word file for desired out put.
I'm trying two create wo dimensions Pre Grp & Post Grp , but my calculations are not working . any help will be greatly Appreciated.
Thanks
3D fall under pre? Is that a rule that anything after the last null goes under post, everything else is pre null?
Hi Sunny ,
yes , pre null values goes to Pre Field & Post null in Post Field .Every month we get new record for ID . so you might have 3d fall there . but it always stores pre null values in pre Field & Post null in Post field. so cinase were we have 3D fall . when we select month Filter Our Post & pre values will change accordingly.
Hey sunny ,
I tried to debug it and looks like ISnull() function is causing issue . is there any alternative for that .. or any new logic I should be using.
try len(<field>)=0 instead of IsNull()
Nope Ram, its not working