Cell formula not displaying value

[ayman_salem]

Hi everyone,

brief description of the issue, I have a table in a business objects report and a cell has a formula but cell is showing blank however when I test this data in a separate tab i get values shown.

Details:

The calculation is the total value held against properties which share the same postcode, the value is blank but there is a formula in the cell.

the formula used is

=Sum([First].[Capital Balance] Where([BB_Flag] =1 And [vSamePostcodeFlag]=1) ForEach([First].[Loan Id];[vSecurityPostcode]))

vSecurityPostcode = Replace([Property PostCode];" ";"")

vSamePostcodeFlag =If( (Count([vSecurityPostcode];All) In([First].[Loan Id];[vSecurityPostcode]))> 1; 1;0)

When i remove the variables vSamePostcodeFlag & vSecurityPostcode then i get an overall value, so i put these into a separate report tab to see if the data changes.

In the table i put the account number, postcode and the postcode flag (redacted below):

The flag works correctly and only shows those values that have the same postcode, if i remove the vSecurityPostcode column from the table the flag becomes wrong and puts it against every account which it shouldnt do.

I think vSamePostcodeFlag is trying to reference vSecurityPostcode but since it is not in the main table the value is not showing. Is there any way around this ?

Thanks

[ayman_salem]

In the first picture, is the value in a different table or in a different column in the same table (since both are shown as one table)?

[ayman_salem]

If you think "vSecurityPostcode" is the problem, add it to the table and see the result. If the correct result is displayed, then you can hide the column with the "vSecurityPostcode".

[Former Member]

The value itself needs to be a sum balances for all accounts that share the same postcode, i will try the above and get back to you. Thanks.