Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
could you help me?
error in expression
IF((Commessa = {'ASSTEL'}), 1,sum({<Commessa = {'ASSTEL'}>} [TotOreLavorate]))
I can not understand what's wrong
Try this
If(Comessa = 'ASSTEL',1,Sum( {<Commessa = {'ASSTEL'}>}[TotOreLavorate]))
May be this?
If(Commessa = 'ASSTEL', 1, Sum(TOTAL {<Commessa = {'ASSTEL'}>} [TotOreLavorate]))
The small error is that you have a bracket too much (after 'ASSTEL') and the big problem is that Commessa is a naked field reference. See Use Aggregation Functions!
HIC
Hi,
I may have misplaced the question.
I'm not able to create a function
Column C
if (Commessa = 'ASSTEL' and (CTRAAN = 'C'), SUM(HOUR), 1)
Column N
if (Commessa = 'ASSTEL' and (CTRAAN = 'N'), SUM(HOUR), 1)