Forum Discussion
Solved
Counting Values from another column
Hey (first post here so I'll try to be thorough) - an example of my table below. ID TITLE CLI Campaign Call Reason 1 111 <null> New sale <null>...
hey,
think ive managed to fix it from using a very old thread using the below - seems to do the trick
Callback on SMS =VAR _B =FIRSTNONBLANK ( Call_List[TITLE], "" )VAR _C =CALCULATE (COUNTROWS ( 'Call_List' ),FILTER ( ALL ( 'Call_List' ), 'Call_List'[CLI] = _B ))RETURNIF ( ISBLANK ( _C ), 0, _C )
To add to the above (cant edit)
The resulting table would be something like
ID TITLE CLI Campaign Call Reason CallbackonSMS
1 111 <null> New sale <null> 0 or no
2 <null> 111 <null> Sales Query 1 or yes
3 333 <null> Cancel <null> 0 or no
4 <null> 333 New Sale Sale sold 1 or yes
5 333 <null> New Sale Sale not sold 0 or no
6 333 <null> Cancel Sale sold 0 or no