Absolute value on List

Jsdeloria21

Hi Community,

I would like to inquire something to make absolute value on a module with specific list members only.So the requirement is that the COS and Admin list members will be alsolute value. see below.

Blueprint view:

only the highlighted items should have an absolute value. the columns are the line item and the row is a list.

Any idea on how this is done? Any suggestions is welcomed.

Regards,

AjayM

Hi @Jsdeloria21 ,

I believe simpler solution is to use a boolean linitem ("Absolute Items?") dimensioned by the list, where you enable TRUE for admin and COS list items. And then using IF THEN ELSE upon this boolean check, modify the formulae slightly for each lineitem.
Ex: IF SYS <List Name>.Absolute Items? THEN ABS(Actual-Budget) ELSE Actual-Budget

Cheers!