How Do I Write An If Statement in PowerPivot -


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