Counting number of rows of a table based on a condition and displaying on a text object

[#1]

Hi,

I have a straight table with one dimension and 2 expressions. So, basically, there are 3 columns in the straight table. I want to count the number of rows of this straight table, where the value of the 2nd expression is greater than 0 and display the same in a text object.

For eg: if there are 100 rows in the straight table and only 50 of them has a greater than 0 value in the 2nd expression, I want a text object to show it as 50.

Request help to achieve this.

Thanks Much,

Tutan

[#2]

Use Aggr function and check

soething similar as given below

sum

(aggr(if(Date(LOAD_DATE) >= Date(From_Date) and Date(LOAD_DATE) <= Date(To_Date), Sum(IMPACTED_NET_CREDITABLE_AMT)),Fact_Typ,BUSINESS_UNIT))

Date(LOAD_DATE) >= Date(From_Date) and Date(LOAD_DATE) <= Date(To_Date),  --- this is my condition..similarly you can put your condition to check the >50

Fact_Typ,BUSINESS_UNIT are my dimensions

[#3]

Hi,

Please find the attached file Hope it helps you

[#4]

Hi,

Please try this expression in the second expression column

=Count({<sales={">0"}>}TOTAL SKU_ID)

[Sokkorn]

Hi Tutan,

Can you share your second expression here?

Regards,

Sokkorn

[#6]

Hi Sokkorn,

Here is my expression which I am using:

num($(vInv_Turn_YTD_TS),'#,##0.00')-num($(vInv_Turn_PY_YTD_TS),'#,##0.00')

[Sokkorn]

Hi Tutan,

I noticed that you have use variable in your expression. Can you help to post your variable definition? So that we can figure it out together.

Regards,

Sokkorn

[Sokkorn]

Or possible attached your sample app here.