Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
this should be fairly easy for an experienced user, but has caused me some issues today.
I have the following if-statement ( returns the correct value):
=count (if ( right (SourceCode_Auto,4) = '7932' or right (SourceCode_Auto, 4) = '7966', [Interest_IdCount]))
i.e. I have 2 conditions and one has to be fulfilled for the count to kick in. The SourceCode field is of the format xxxNNNNN, minimum 4 digits/letters and maximum8.The condition needs to be on the 4 last ones.
now, I tried this set analysis ( returns a too low value
=count ( { $ < [SourceCode_Auto] = {'*7932', '*7966'} > [Interest_IdCount] }
Why doesn't that work out, and how should it be written?
many thanks to the person that might take pity on a beginner and explain this mystery.
here for more on set analysis
and it does! thank you so much!
merci beaucoup!