Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can anyone see a problem with the below formula?
sum{$<left(OverHeads,7) = {"SICKNESS"} >} [Total Hours])
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
try this
=sum({$ <OverHeads={"SICKNESS*"}>} [Total Hours])
SICKNESS length is 8
Try this...........
=if(left(OverHeads,7) = 'SICKNESS',Sum([Total Hours]))
if(
WildMatch(Subtitle,'ABC*'),Left(Subtitle,5),sum(value))
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
thank you thats got it