General OBIEE

Get Involved. Join the Conversation.

Topic

    Aloka Bhattacharyya
    Is it possible to use SUM on a column where...
    Topic posted September 17, 2018 by Aloka BhattacharyyaBronze Trophy: 5,000+ Points, last edited September 17, 2018, tagged BI Publisher, OBI Answers, OBIEE Answers, OTBI 
    159 Views, 5 Comments
    Title:
    Is it possible to use SUM on a column where COUNT(DISTINCT(column) ) is used?
    Summary:
    Is it possible to use SUM on a column where COUNT(DISTINCT(column) ) is used?
    Content:

    Hi,

    Is it possible to use SUM on a column where COUNT(DISTINCT(column) ) is used?

    I don't see the summation icon in Layout tab for these columns. Is there anyway to get a sum for these columns where I have used a COUNT(DISTINCT) on an OTBI Report?

    Thanks,

    Aloks

    Comment