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

Trying to list Base members using WITHATTR function

Summary:

 I am trying to allocate the expense for 2 different projects based on a input project entered by user.

Here is my logic. Logic validates fine and it runs without any issues but i dont see the values populating in the target proejct. This is not a block issue because when i replace the whole @WITHATTR function with the base member then it gives the values. Looks like WITHATTR has issue listing the base member values. Any help would be great.

"10000-00" = @SUMRANGE("NON_ICT_SUBCATS",@WITHATTR("ICT","==","ICT_26")); — Runs fine but doesnt populates the values.

"10000-00" = @SUMRANGE("NON_ICT_SUBCATS",@WITHATTR("ICT","==",@ATTRIBUTESVAL("ICT_26"))); — Runs fine but doesnt populates the values.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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