Tables with Nulls and Without nulls

[Anonymous]

Hi

I am trying to separate a table into 2 tables - one with Nulls in SLA Fields  ( SLA_TP99 and SLA_FCI ) AND one without Nulls in SLA Fields ( SLA_TP99 and SLA_FCI ) .. and their corresponding record counts in the captions of the tables .. I tried using SLA_FCI={'*'} and SLA_TP99 ={'*'} in all my expressions but it does not seem to work , can someone please take a look .. attached is my application.

Please note I have alternate states in my app

Thank you,

[sunny_talwar]

I am taking a peek, will let you know if I find anything

[sunny_talwar]

The issue here is that the SLA_TP99 is not truly null here

But you expression for Count is forcing it to be null

If("Count", only({<ServiceTimeSeries.Date={'>=$(=Date(vStartDate))<=$(=Date(vEndDate))'}>}SLA_TP99))

Now if I decide what the count is based on SLA and SLA is based on the Count, I will have an infinite loop. Can you make sure that it is certainly not required?

[Anonymous · Accepted solution]

Actually there is a value for sla tp99 on 5/1 .. Not sure what was the issue with earlier expressions , but I slightly modified your expression . created a rowno in script , and used it for displaying values with Null in second table .. this seem to work .. still testing though ..

[sunny_talwar]

Great, I like people who try things at there end

Please remember to close the thread by marking correct and helpful answers.

Best,

Sunny

[Anonymous]

Sure .. thank you for taking a look at it again!

[sunny_talwar]

Not a problem

Thank you for taking my advice

Best,

Sunny