Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ...
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
Hi,
you already got the '0' value in your text box when there is no selection, right?
how do you want that?
Thanks for reply Settu,
But when I select any month, even I get 0 (zero).
Hi,
Refer to the attachment, can you share your mock app? Tks
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?
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
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