cancel
Showing results for 
Search instead for 
Did you mean: 

Count Function based on Condition in webs 3.1

Former Member
0 Kudos

Hi Folks,

I have below requirements need to calculate and then find the MTD.

SalesOld SalesDifference
20400400-20
100200200-100

Actual Requirement

YTD SalesYTD Old SalesDifference
20400400-20
100200200-100

In report I have type name and typeid fields

Condition for Sales: Select  count(t1.type_name),t2.typeid from table_name1, tables_name2 where t1.type_name='ABC' and t2.typeid='A'

Old Sales: Condition

Condition for Sales: Select  count(t1.type_name),t2.typeid from table_name1, tables_name2 where t1.type_name='ABC' and t2.typeid NOT IN 'A','X'


Please suggest me how to achieve this in webi. I want to count based on mention conditions and then calcualte YTD .


Looking forward your suggestions. 

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

Tô Count something based on a condition try

Count([something] where(condition))

Regards,

Rogerio