Displaying a Null Value

[#1]

Hi Friends,

Please let me know if any one can help me on the logic for the below.

Based on the "Group" selection we need to check the "FINAL" field  whether it has any null values or not.If there is any one null value, We Need to Give a Message in a Textbox  as " Yes final has a Nullvalue" or else " No null values".If no selection in the Group field the Text should  display "Final field has null values or not" based on the same condition.

Let me know if i need to re frame the question.

Thanks and Regards,

Regards,

Pooja.

[sunny_talwar]

May be this:

=NullCount(Aggr(Amount1*Amount2, No, Title, Item, Group, test))

[#3]

Hi Sunny,

Thank you so much for your valuable time.

The above script is working. But still i have a concern, why we need to check with all the fields. If i check only with the Group field the answer is not coming. Below is my edited code.

=NullCount(Aggr(Amount1*Amount2, Group)) > 0, 'Yes Final has Null', 'No Null Values')

Why i have this doubt is, in future if we are adding some more fields in the DB. do i need to add those fields also into this script right..!! So instead can we check the conditions only between these "Group" and "amount1*amount2" fields.

Hope you understood my query.

Regards,

Pooja

[sunny_talwar]

I think the problem is that when you are aggregating on Group only, Amount1*Amount2 is always null.

May be you can try with this:

=If(NullCount(Aggr(Amount1*Amount2, Group, No)) > 0, 'Yes Final has Null', 'No Null Values')