Forum Discussion

rpinxt's avatar
rpinxt
Solution Sage
2 years ago
Solved

Calculating on Parameter fields

I have a parameter field : Now based on the selection I want to make calculations. I have this : FTE Outbound = IF(MAX(PrmOutbUnits[PrmOutbUnits]) = "Outbound Direct", CALCULATE([FTE],'AVN...
Need Help
  • rpinxt's avatar
    rpinxt
    2 years ago

    Nevermind...should not have used MAX.

    Now use selectedvalue and it works.

     

    But you have to make an extra column in your parameter table being a copy of the first field (PrmOutbUnits), I named it "PrmOutbName".

    The first field you cannot use because of the composite error you then get.

    With the new column you will not have this problem.

rpinxt's avatar
rpinxt
Solution Sage
2 years ago

Nevermind...should not have used MAX.

Now use selectedvalue and it works.

 

But you have to make an extra column in your parameter table being a copy of the first field (PrmOutbUnits), I named it "PrmOutbName".

The first field you cannot use because of the composite error you then get.

With the new column you will not have this problem.