You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

@ISMBR BSO member formula issue!

Received Response
30
Views
6
Comments
edited Aug 2, 2018 2:36AM in Essbase 6 comments

Summary

@ISMBR BSO member formula issue!

Content

Hello All,

I am writing a member formula to calculate if specific model is not Europe or Australia and Model year 2017,2018 then import duties should be 0 else for specific model import duties should 0.3*FOB(US$).And ifelse condition for all the remaining model which is not specified in the formula should be 0 for Australia and Europe for Model Year 2016 else it should .006*FOB(US $)

Below is the formula which I tried and it working fine if I have only 5 to 6 models in the formula,If add upto 70 models then the formula is not calculating as expected

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!