Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, hope someone can help me.
Here's my data
Name | From | 1st interview | offer | withdrawn | Started | desired |
Totals | 3 | 2 | 1 | 2 | 1 | 1 |
aaaaaaaa | 1 | 1 | 1 | 1 | 0 | 1 |
bbbbbbb | 1 | 0 | 0 | 1 | 0 | 0 |
ccccccccc | 1 | 1 | 0 | 0 | 1 | 0 |
I would like to make the desired column. Logica: if a name is withdrawn after having an offer then 1. If a name is withdrawn but had no offer then 0.........
The columns are made this way:
offer: SUM(IF(UserTrackTypeExtended='Offer', 1))
withdrawn: Sum([#IsWithdrawTrack])
Thank you for your help!
Regards, Elmer
It's more efficient to handle this logic by creating flags in the back end and rely on simple sum expressions at the front end.
You may want to provide a sample of the data and the expected output for assistance.