Set Analysis issue

[nirajagarwal]

Hello,

I am having a field in table for which i am using below expression

Count(DISTINCT{<[AuditSheetLabel] = {"=Sum({<AuditTimestamp = {[*]}, AuditType ={'Sheet'}>} Audit_Count) > 0"}>} [AuditSheetLabel])

so what happening here is this expression doesnt give me proper output but once I select any record from the table it gives me proper output.

could you please tell me what am I missing here.

[lfetensini]

Remove {[*]} from AuditTimestamp

Count(DISTINCT
{<
[AuditSheetLabel] = {"=Sum({<AuditTimestamp =, AuditType = {'Sheet'}>} Audit_Count) > 0"}
>}
[AuditSheetLabel])