Hi All,
i was trying to find out Max and Min Salaries based on Country, Legal entity and Department.
I tried using the Max function based on all three dimension but gave a output value as infinity.
Is there any way the output can be achieved?
Hi @akprasa1
That's an expected behavior of Anaplan, as mentioned in https://help.anaplan.com/c5c1e687-3d55-46ea-ab28-a7603eade586-x[MIN:y]
You will see the following when you scroll down.
Having said that, what exactly are you trying to achieve. It'll help the forum members to come up with a suggestion if you create a mockup in excel and attach relevant screen shots.
Thanks,
LipChean
Hello, I have a use case where a user will create a child if they want to make adjustments to an initial value entered at the parent level. The reason the "parent" list may not have children is that not all the list members will have adjustments. The users want to see all L1 items on the same grid as L1 items with L2 items…
We have a question regarding the behavior of the XL3dowriteback formula. Our understanding is that this formula allows writeback to be controlled on a cell-by-cell basis. In our operation, when we need to clear a previously written-back value due to an input error or similar reason, we do so by entering 0. However, when…
We added new bed types to eventually move from the old "All Beds, single, double" I inputted the data into the new bed types Went to double check flow into other modules and found that they are being double counted even though I blanked the original columns out. I am not sure why it is still counting All Beds even if it is…
