SUM by Column Header

JTCairns

Hi All,

I'm trying to apply a rule to a set of columns i have (appx 90). I want to say something along the lines of

If [Columnheader] contains [Keyword] then multiply [Columnvalue] by 12.

I have been looking at the multi row and field tools but i am struggling a bit. Any help would be great

Cheers

Help

Expression

Accepted answers

BenMoss

Your statement should work. Maybe you have the option 'Copy Output field Add' checked which is creating a new field for every variable on the far right of your data which you cannot see.

Attached example of your logic implimented and working.

Ben

MultiField.yxmd

All comments

JTCairns

I have tried this

IF CONTAINS([_CurrentFieldName_],"TOBEUSED") THEN [_CurrentField_] * 12
ELSE [_CurrentField_]
ENDIF

BenMoss

Your statement should work. Maybe you have the option 'Copy Output field Add' checked which is creating a new field for every variable on the far right of your data which you cannot see.

Attached example of your logic implimented and working.

Ben

MultiField.yxmd

LordNeilLord

Hey @JTCairns

I'd add a recordid and then transpose the data (grouping on recordid)

Add a formula tool with your formula

crosstab the table back (grouping on recordid)

JTCairns

@BenMoss @LordNeilLord Thanks guys both of these suggestions helped

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703