Formula to be used in WEBi Report(Calculation)

building reports webintelligence
1

Hi,

My requirement is I want the Report to be shown below basically the report shud show monthly transaction details

Starting of the report shud show OPENING BALANCE for that customer

Then it should display two columns like transaction amount and balance where transaction amount shouwa the amount that is debited or credited and balance show the balance after corresponding credit and debit.

And at end of the report it should show the closing balance

Shown below the example

OPENING BALANCE :: 315,000

TRANSAMOUT BALANCE

+5000 (Openingbalance + transamount) i.e 320000
-1000 (Previous balance - 1000) i.e 321000

Closing BALANCE :: 321000

i dont have access to Universe or database can any one help me what formula if i use i can acheive the above logic ?

Your help is very much appreciated

Thanks & Regards
Sashu

Sashu_11111 (BOB member since 2011-06-16)

2

Apparently, you can do this placing Opening Balance in a cell on the body and place a block(table) with Relative Position to the Opening Balance Cell and then place another cell at the bottom of the block with relative position to the block.

Otherwise use only one block and extend the Header and Footer of the table by adding extra rows and merge those rows to display Opening balance in the header and closing Balance in the footer.

But one thing unclear to me is, all the values you are trying to display are measures, dont you have any dimensions to display in the report.

jprasanthram :switzerland: (BOB member since 2010-12-10)

3

Thanks for your reply…I do have dimension but my calc part cums here…

structurewise i am comfartable i need the formula i.e the 1st row balnace value depends on opening balance amount and second row’s Balance depends on 1st rows balace.

can you tell me which formula we can use to acheive this ?

Thanks & Regards
Sashu

Sashu_11111 (BOB member since 2011-06-16)

4

Don’t you have Opening Balance and Closing Balance as individual measure objects?

jprasanthram :switzerland: (BOB member since 2010-12-10)

5

I have only opening balance and Transaction amount in the table.
yes both are individual object

Sashu_11111 (BOB member since 2011-06-16)

6

You can use

 =Sum(Opening Balance) In Report

to get the Opening Balance.

Is there any reference field or flag using which we can identify these 2 records separately? only then you can use that to manipulate your (opening balance+ TransAmount) and (previous balance - transamount)

TRANSAMOUT BALANCE

+5000 (Openingbalance + transamount) i.e 320000 (Pos)
-1000 (Previous balance - 1000) i.e 321000 (Neg)

jprasanthram :switzerland: (BOB member since 2010-12-10)