Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How do we count using multiple Conditions along with null value ..?
For Example,
I am counting null value and my expression is below.
1st Expression ==> =Count(If(Len(Trim([Sales]))=0,[Sales]))
with the above, i just want to check two more condition as mentioned below.
2nd Expression ==> ({<[Current Status] = {'*ISSUE FOR CHECK*'}>} DISTINCT [PRODUCT ID NUMBER])
How do we combine 1st and 2nd expression. It means How do we count using multiple Conditions along with null value ..?
May be like this
Count({<[Sales]= {"=len(trim([Sales])) =0"},[Current Status] = {"*ISSUE FOR CHECK*"}>} DISTINCT [PRODUCT ID NUMBER])
May be like this
Count({<[Sales]= {"=len(trim([Sales])) =0"},[Current Status] = {"*ISSUE FOR CHECK*"}>} DISTINCT [PRODUCT ID NUMBER])