This content has been marked as final.
Show 4 replies

1. Re: Mode Calculation; Need to compute modal price for a series of products.
Vasil Petkov Oct 30, 2015 4:30 AM (in response to Andrew Esham)Hi Andrew,
Please check the attached solution and let me know if that's what you were looking for.
Best,
V

Mode Test DB Solution.twbx 15.5 MB


2. Re: Mode Calculation; Need to compute modal price for a series of products.
Andrew Esham Oct 30, 2015 10:55 AM (in response to Vasil Petkov)Vasil,
This is genius! Thank you very much. Problem solved!
Andrew

3. Re: Mode Calculation; Need to compute modal price for a series of products.
Yi Lin Chen Apr 13, 2017 7:16 AM (in response to Vasil Petkov)Hi Vasil,
I am doing the same thing, I just have one problem, when there are 2 modes it only returns the bigger value. Is there a way around this where it returns both? I created another field where its a true if it is the mode and would like both modes to show up
Best,
Lin

4. Re: Mode Calculation; Need to compute modal price for a series of products.
juan perez Jun 29, 2017 8:54 AM (in response to Andrew Esham)Hello
I am trying to open the workbook added by Vasil Petkov and it does not show the viz. I am opening it with 10.2 version, by the way.
What should I do in order to see the solution? Thanks