Hi I have a enum field โStyle of curtainโ and it has drop down option such as Plain curtain,Eyelet curtain. So what I am trying to achieve is to calculate cost of stitching & based on the style of curtain selected the formula has to get applied and I have written the formula as such but getting an error as below :
Cannot compare Text with List in ([Style of curtain to be stiched] = LIST(โPlainโ,โPlain with liningโ,โRod pocketโ,โRod Pocket with Liningโ,โBackloopโ,โBack loop liningโ))
Formula is :
IFS([Style of curtain to be stiched] = {โPlainโ,โPlain with liningโ, Rod pocket,Rod Pocket with Lining,Backloop,Back loop lining},([Lengths required] * [Rate per length (Curtain)]),([Length required] * [Rate per length (Curtain)]))
If any one could help me out where I am going wrong?
Solved! Go to Solution.
Please try
IF(IN([Style of curtain to be stiched], {โPlainโ,โPlain with liningโ, โRod pocket,Rod Pocket with Liningโ , โBackloop,Back loop liningโ }) ,([Lengths required] * [Rate per length (Curtain)]),([Length required] * [Rate per length (Curtain)]))
Please try
IF(IN([Style of curtain to be stiched], {โPlainโ,โPlain with liningโ, โRod pocket,Rod Pocket with Liningโ , โBackloop,Back loop liningโ }) ,([Lengths required] * [Rate per length (Curtain)]),([Length required] * [Rate per length (Curtain)]))
Thank you sir the solution did work for me.
For reference:
Thank you
User | Count |
---|---|
43 | |
32 | |
25 | |
23 | |
14 |