Hi - struggling to get my head around this. Not sure if I'm getting the syntax wrong, or whether what I'm trying to do simply isn't possible. I want the model user to be able to make a selection in a drop-down list from a number of different allocation profiles to use in the PROFILE function. To hold the different profiles, I need to have a 3-dimensional module ("Profiles") containing Lists for "Profiles" and "Relative Periods", and a single line-item to hold the profile value. In my module that is going to perform the calculation, 12v Air Compressor I have line items for: Value: the line item that needs to be profiled; Profile: the profile to be selected (formatted on the List "Profiles"); the PROFILE function. How can I set up the PROFILE function to enable the user to determine which profile to use? Thanks!
You can use Line item subsets rather than IF...THENs
1. Create a line item subset from the initial profile module and a module dimensioned by this LISS with the COLLECT() function
2. You can then set up a user choice module using the LISS formatted line item and pull in the COLLECT() line item against the user using a Lookup from the choice module
3.Then you will need to have the calc module dimensioned by user to pull in the profile from 2.
The calc module could end up being quite large if you have a large number of users
I hope this helps