does anyone have any brilliant formulas for lookin...
# suiteanalytics
b
does anyone have any brilliant formulas for looking for the lack of data? I would like to run a search that looks for certain parent records that don't have any of a certain sub-record. I have a Locale record that has wage information tied to it as a sub, but some of these locale's do not have any wage information. I need a way to represent these in a list if possible. I tried regular criteria of: inactive = F, childrecord.sub-topic = wage information | summary criteria of: count of childrecord.internal ID = empty (and tried 0, neither way worked). If you invert the summary criteria though (childrecord.internal ID != empty), it results all the ones that I'd expect, so I was hoping there is a way to do the opposite. but I know looking for the lack of information is/can be difficult. hopefully this makes sense.
We got this figured out. At least for our use case. Resolve was: regular criteria of inactive = F | Summary criteria of: formula (numeric) = sum of case when {childrecord.wageinformation} = 'Wage Rate' then 1 else 0 end = 0 | results are: formula (numeric) = sum of case when {childrecord.wageinformation} = 'Wage Rate' then 1 else 0 end, group by parentname. hope this helps someone else out.