Default value in selection

[Anonymous]

Good Morning Everyone,

Today while working in a Dashboard I got the requirement to make the text box value by default 0 ( zero ).

When I select any month it will give the value for that respective month only.

In Short, I am not in need to populate Cumulative Numbers.

1) Text Box

2) Expression : =If(GetSelectedCount(Month)=0,0,Count(GID3))

but the expression is not working ...

[settu_periasamy]

Hi,

you already got the '0' value in your text box when there is no selection, right?

how do you want that?

[Anonymous]

Thanks for reply Settu,

But when I select any month, even I get 0 (zero).

[devarasu07]

Hi,

Refer to the attachment, can you share your mock app? Tks

[settu_periasamy]

Can you try to separate the expression and put into two text box?

like

GetSelectedCount(Month)   - what it is showing when you select the Month?

Count(GID3)  - what is the count?

[Anil_Babu_Samineni]

Your expression condition seems working because When we are not selecting any thing from Month it will return 0 then Condition. Will you able to do with Count(GID3) then show us the Value after selecting the Month which is returning value. then will look into

[Anonymous · Accepted solution]

Yes I got the answer,

My Script was this.

LOAD GID as GID3,

     Month as Month1,

     Year as Year1

FROM

but in Expression, I used Month which supposes to be Month1