Creating a calculated column from calculated fields

Question

I am trying to create a calculated column in a task report that sums a number of calculated fields.

The fields are in Currency format and some may contain null values.

I have tried the following code with no result:

displayname=Y1 Profit Total
textmode=true
valueexpression=(IF(ISBLANK({DE:PD - AA EA Y1 GP $}, "", 0, {DE:PD - AA EA Y1 GP $}) + IF(ISBLANK({DE:PD - AA MPK Y1 GP $}, "", 0, {DE:PD - AA MPK Y1 GP $}) + IF(ISBLANK({DE:PD - AA CAR Y1 GP $}, "", 0, {DE:PD - AA CAR Y1 GP $}) + IF(ISBLANK({DE:PD - BB EA Y1 GP $}, "", 0, {DE:PD - BB EA Y1 GP $}) + IF(ISBLANK({DE:PD - BB MPK Y1 GP $}, "", 0, {DE:PD - BB MPK Y1 GP $}) + IF(ISBLANK({DE:PD - BB CAR Y1 GP $}, "", 0, {DE:PD - BB CAR Y1 GP $}) + IF(ISBLANK({DE:PD - CC EA Y1 GP $}, "", 0, {DE:PD - CC EA Y1 GP $}) + IF(ISBLANK({DE:PD - CC MPK Y1 GP $}, "", 0, {DE:PD - CC MPK Y1 GP $}) + IF(ISBLANK({DE:PD - CC CAR Y1 GP $}, "", 0, {DE:PD - CC CAR Y1 GP $}))
valueformat=currencyString

Any help would be amazing, thank you.

skyehansen · Accepted Answer

I don't think I've ever seen null values being a problem that one would have to workaround. Did you try a simple sum? SUM({DE:field1},{DE:field2},{DE:field3}, and so on...)?

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded