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.
Tagged:
0