Subraction Fourmula

building reports webintelligence
1

Hi all,

I am working on BOXIR3.0 in infoview…I am creating in corss tab…

I want to do the substraction in 2 columns…

EX:- currentweek - previous week

      20-10=10

Can you please help me in this formula.

Thanks & Regards,
Naveen

venki.dmm (BOB member since 2008-09-11)

2

Use Previous() function to get previous week data.

Hope it helps you…!!

Thanks

BOCP (BOB member since 2007-07-02)

3

Hi BOCP

Thanks for your reply…

My pleas fine the attachment.

Thanks & regards,
naveen
difference.xls (20.0 KB)

venki.dmm (BOB member since 2008-09-11)

4

Try it:



Diff= [Curr Wk] - [Wk-1] ForEach  In [Country]

Thanks

BOCP (BOB member since 2007-07-02)

5

Hi BOCP,

Can you explain the the formual more,

Thanks & Regards,
Naveen

venki.dmm (BOB member since 2008-09-11)