If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

How to show filtered expression from a querycalculation

Started by PeterDD, 05 Aug 2019 03:04:37 AM

Previous topic - Next topic

PeterDD

Hi,

in a query there is a field with ledger items (1 to 9000) and amounts
in the page designer a need to show some amount for specific ledger items

I've created a expression:
Case when [ledger item] = '8995'
then [ledger_amount]
else 0
end


but in the page design I only want to show the value <>0
is it possible to make an query calculation that looks like this:

total([ledger_amount] where [ledger item= '8995']) ????

or is there another solution?

thanks

BigChris

I don't know if I'm missing something, but don't you just need a filter that's something like [Ledger Item] = '8995' and [Ledger_Amount] <> 0

PeterDD

Well I need to show more than 1 row for multiples ledger items,
so when I Add a filter it will show only 8995

so in my page layout the first row is to show 8995

then 8603
       8612
8602

6000+ 6001
etc.