Skip to Content
0
Former Member
Dec 04, 2008 at 05:47 PM

how to find the difference between two columns

384 Views

Hi Everyone,

I have a deski report which is build from a single query. The report contains two tables.

Table-1:MTK Loc

MTKnet

Table-2:WTK Loc

WTKnet

Now i need to find the difference of the columns WTKnet and MTKnet.

These two are report level variables.Their definitins are as below:

MTKnet:=Sum((<Fees Collected by Per Collected>) In Body) ForEach <vMTKLocation>

WTKnet:=Sum((<Fees Collected by Per Collected>) In Body) ForEach <vWTKLocation>

Where <Fees Collected by Per Collected> is universe variable.

Please help...

Thanks in Advance......

FYI:

By mistake i posted this in WEBI so iam posting it again in deski