Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community
I have a straight table in that I am calculating an expression that will display the count of materiel for all the days started from Sunday to Saturday as below.
Division | Expression =aggr(count(materiel),Division) |
---|---|
Atlanta | - |
New jersey | 2000 |
New York | 523 |
Texas | 251 |
CDC | 412 |
Sidney | 321 |
Here for my Dimension Division field value Atlanta i am getting a null value so
here I want to populate a value that is calculated for the days Monday to Friday instead of null value for Atlanta.Can someone let me know the possible ways to handle it.
Thanks
you actually want to show a different expression result if the result from your expression is null, right? then did you try an if statement?
something like
=if(isnull(expression1), expression2, expression1)
Do you have value for Atlanta in the sources?
Also please place sample data and app to check ... thanks
Hi Jsaradhi
I Tried but it hasn't taking that expression2 as you suggested.
Thanks
John
Hi Nagaraj Rangaiah
I Have data for Atlanta but sun day I don't have the data for that I want to display up to Friday data.
Thanks
HI John,
Unable to test but just thought this would help you. Please
try to follow the below link that should get you the answer I presume.
--> Answers By Steve Dark and Erico.
Can you post sample app
make your expression as such:
sum(aggr(Count(Material),Division))
this will display 0 instead of null
HI,
You can try this,
If(ISNULL(Your field name),Peek(Yourfieldname), Yourfieldname) AS Yourfieldname
This will fetch the last value,Once you have values for every division
Dimension Division field value.
after having values then you might not face any issue.
Thanks
or solve it in your script.
test with if(len(fieldname)=0,....... and set field to 0