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

[JTCairns]

I have tried this

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

[BenMoss · Accepted solution]

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

[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