using a left in set analysis

[samuel_brierley]

Can anyone see a problem with the below formula?

sum{$<left(OverHeads,7) = {"SICKNESS"} >} [Total Hours])

[maxgro]

try this

=sum({$ <OverHeads={"SICKNESS*"}>} [Total Hours])

SICKNESS length is 8

[kiranmanoharrode]

Try this...........

=if(left(OverHeads,7) = 'SICKNESS',Sum([Total Hours]))

[nizamsha]

if(

WildMatch(Subtitle,'ABC*'),Left(Subtitle,5),sum(value))

[Clever_Anjos · Accepted solution]

You can´t use a function to modify a field name.

Possible workarounds:

1) Create a field at script level left(OverHeads,7) as filterfield

2) Using "if" as Kiran proposes

3) Using "*" modifier as Massimo proposes

[samuel_brierley]

thank you thats got it