Hi,
I have a scenario where I am creating a calculator that relies on various budget areas within an Option Set on a specific item within a Model Driven Application. My issue is that I need to map that selected budget area (Option Set) to a variable within the application.
Eg Option Dog, Cat, Bird.
I need to map the Dog to the Dog Variable, Cat to the Cat variable and so on. Is my best way to do this via a Collection and manually map them?
The scenario would then be to take that mapping and apply to a calculation I have:
Set(
AminalWalksvariable_WalksWeCanDeliver,
AnimalTypevariable_Items.'Animal' / (LookUp(
CostPerWalkvariable_LineItems,
'Product' = [@'Product'].'Pet Store'
).Price)
);
I tries to remap the above based on my scenario without giving away the privacy of the client I am working on etc but the logic flow steps is something that should make sense (I hope). The key outcome I want is I want the option listed in RED to refer back to a variable so I can calculate as per my first scenario regarding Dog, Cat, Bird.
If a collection isnt the best way and if there is an easier way to map these then I am all ears.
Thanks a lot!
