Skip to Content
0
Jan 28, 2016 at 10:17 PM

variable generating extra row - how to remove

18 Views

Hi,

I created a Dimension named HoursPeriod contains multiple if statements. When drag on the report, at the end it generating extra row.

Kindly let me know why its generating extra row at bottom. I can hide and show this one. But i don't want to do.

Please let me know how to remove. Is any modification here in the following code blow.

HoursPeriod

-------------------------

=If([Dur] Between (0;3);"0-3";

If([Dur] Between (3;6);"3-6";

If([Dur] Between (6;9);"6-9";

If([Dur] Between (9;12);"9-12";

If([Dur] Between (12;15);"12-15";

If([Dur] Between (15;18);"15-18";

If([Dur] Between (18;21);"18-21";

If([Dur] Between (21;24);"21-24"

))))))))

Thanks.

BR

Kashif

Attachments