Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello:
I need some assistance calculating the following scenario:
Here's an example of where the above expression works fine: APP ALLOCATION = 0.25, Charge Amount = 900, PRODUCT AVAILABILITY = Workgroup Server Business, so using the expression =[Charge Amount]*[APP ALLOCATION] I get $225 which is correct.
However, when PRODUCT AVAILABILITY = Server Port Connectivity 1GB (GBL) or Server Port Connectivity 10GB (GBL), the APP ALLOCATION number should not be used and the full Charge Amount should be used. For example, when PRODUCT AVAILABILITY like "Server Port Connectivity" use full Charge Amount (PRODUCT AVAILABILITY = Server Port Connectivity 1GB (GBL), Charge Amount = $115, then my total for that line item should be $115).
Any ideas on how I incorporate this scenario into the expression? Does this make sense? Thanks in advance.
Try this:
if(not Match([PRODUCT AVAILABILITY],’Server Port Connectivity 1GB(GBL)’,’Server Port Connectivity 10GB(GBL)’),[Charge Amount]*[APP ALLOCATION], [Charge Amount])
Thanks,
Sangeetha
Try this:
if(not Match([PRODUCT AVAILABILITY],’Server Port Connectivity 1GB(GBL)’,’Server Port Connectivity 10GB(GBL)’),[Charge Amount]*[APP ALLOCATION], [Charge Amount])
Thanks,
Sangeetha
Can you post a sample app with dummy data that best replicates your scenario
Hello Sangeetha:
Your expression works with a couple of little tweaks. For whatever reason, the single quote marks came across non-normal when I copied the expression, but I simply changed them to my keyboard's style. Then and this is my fault, there's a space between GB and (GBL). I made those two changes and it worked like a champ!!! Thank you very much for your assistance.
Quick question, if I come across another item where I have to do the same thing by adding it to this expression, I simply put a comma after 10GB (GBL)', right? In other words like this:
if(not Match([PRODUCT AVAILABILITY],’Server Port Connectivity 1GB (GBL)’,’Server Port Connectivity 10GB(GBL)’, 'New Item To Not Multiply'),[Charge Amount]*[APP ALLOCATION], [Charge Amount])
Hello Vineeth:
Thanks for your reply. I believe Sangeetha has provided a solution, but I definitely appreciate your interest and reply. Thanks again.
Yes. Just add it to the expression and it would work as expected. Please close the thread if you have your question answered.
Thanks,
Sangeetha
Thank you. I'll mark your previous response as correct. Again, thank you for your help.