Calculation based on two blocks

building reports webintelligence
1

Hi Everybody,
I have two blocks one have sum for all countries and other block have sum based on individual country. I want a variable where calculation is based on both the blocks like (sum for USA/Sum for all countries).
Does In Block works in this case.
I am making a variable but that doesn’t work when a put a block level filter on the block which has countries

Variable= sum in ([country]) InBlock/sum In Block

Please Suggest…

rgupta97 :us: (BOB member since 2005-11-18)

2

Could you try wrapping the NoFilter() function on your formula ?;

[list]= NoFilter(sum in ([country]) InBlock/sum In Block)[/list]

Joe Szabo :us: (BOB member since 2002-08-19)

3

Thanks for reply,
I tried but NoFilter works when filter is applied to report not block.
IS there anything like that for block level filter?

rgupta97 :us: (BOB member since 2005-11-18)

4

How about;

= NoFilter(sum in ([country]) In Section)

You may (or may not) need to tweek but In Section should be what you need.

Joe Szabo :us: (BOB member since 2002-08-19)

5

I tried couple of time with NoFilter option and it did work.
I got with the following formula

=[Sum]/NoFilter([Sum]) In Block

Thanks to everybody for help.

God Bless.

rgupta97 :us: (BOB member since 2005-11-18)

6

You can even try

sum in ([country]) In Report /sum In Block

Satya Vooturi :india: (BOB member since 2009-01-15)

7

Thanks for that, but one of the colums gives me a #CONTEXT error

any ideas pls

Sims786 (BOB member since 2006-04-04)