all,
just started working powerpivot. how write if statement?
i want see if 1 value less another. if is, 0 else 1
=if(agent_daily_intradiem_tint[task name count]<agent_daily_intradiem_tint[total task count]) , 0, 1)
@derlin's edit perfect except paren. correct.
=if(agent_daily_intradiem_tint[task name count]<agent_daily_intradiem_tint[total task count] , 0, 1)
if put calculated column should work. if measure fail believe. did want calculated column?
Comments
Post a Comment