
2. Re: help formula for: by [variable], if [variable1] = 1 then [variable3]
Leslie Raillon Apr 4, 2017 7:03 AM (in response to Kashish Chauhan)Yes...
BUT:
"First Device" should be
NAPlug
NAPlug
NAPlug
NAPlug
NACamera
NACamera
So by user, all rows are completed.
Thanks
Regards
Leslie

3. Re: help formula for: by [variable], if [variable1] = 1 then [variable3]
Kashish Chauhan Apr 4, 2017 7:30 AM (in response to Leslie Raillon)Use these two calculations:
First Device Type:
if [rank with accessories] = 1 then [Nth device type]
end
Now to fill each row for the user with the above value use this calculation:
{ fixed [user id] : min(first device type)}
Thanks
Kashish

4. Re: help formula for: by [variable], if [variable1] = 1 then [variable3]
Leslie Raillon Apr 4, 2017 8:07 AM (in response to Kashish Chauhan)Hi,
THanks that works really well.
One question though: i have a case where for one user with 2 products A and B which are activated at the same time.
So their really is no first product.
First "first device type" I get :
for A A
for A B
for second calculation (when i use f"ixed"), I get:
for A A
for A A
how does he determine which one to keep? does min formula use an alphebetical rull in such a case?
Thanks
Leslie

5. Re: help formula for: by [variable], if [variable1] = 1 then [variable3]
Kashish Chauhan Apr 4, 2017 7:06 PM (in response to Leslie Raillon)Hi Leslie,
Yes you can say that. If only one product was there after a condition gets true than the Min and Max value would have been the same. If you feel I have helped you in any way please mark my answer correct so that it is removed from the "Unanswered threads".
Thanks,
Kashish