Skip to Content
avatar image
Former Member

Count Records as per Table

f i use default count button it is giving provider type code count as 5

but when i am using formula it is giving count as 10

Please advise how to get the count as 5 using Formula

Thanks

Krishna

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Oct 19, 2016 at 01:02 PM

    Check if "retriev duplicate records" option is checked or not Webi query properties.It its tick then untick and try.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 19, 2016 at 02:21 PM

    Also "Avoid Duplicate Row Aggregation" should be un-checked.

    Add comment
    10|10000 characters needed characters exceeded