variable generating extra row - how to remove

[former_member405964]

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

[amitrathi239]

Hi

might be some of values are not in your if else conditions.either add filter where variable is not null or add one else condition to display sone dummy data like "Hide"

Add filter on variable where not equal to Hide

Amit

[former_member405964]

I am already using Hide and Show but this will not fulfill the requirements as per the following calculation.

Thanks.

[former_member405964]

Thanks got the solution.

=Count([ID])/NoFilter(Count([ID])) In Block   (This gives the result what I was looking for).

:

Both the percentage with or without filter is same.