Help with Calculated dimensions

[arusanah]

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

[sunny_talwar]

3D fall under pre? Is that a rule that anything after the last null goes under post, everything else is pre null?

[arusanah]

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.

[arusanah]

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.

[#5]

try len(<field>)=0 instead of IsNull()

[arusanah]

Nope Ram, its not working