Experts,
need help here.
I tried to do a multilple IIF, but the results always come out on the first one, how can i tie the conditions and each should act accordingly. Here is the code.
=IIf([First of Codecat]=1,[AccessTotalsmuamaladate_By_Month]*0.25,[calculate]), IIf([First of Codecat]=2,[AccessTotalsmuamaladate_By_Month]*1,[calculate]),IIf([First of Codecat]=3,[AccessTotalsmuamaladate_By_Month]*2,[calculate])
System only recognize the first condition. Appreciate your help and thankyou in advance.
need help here.
I tried to do a multilple IIF, but the results always come out on the first one, how can i tie the conditions and each should act accordingly. Here is the code.
=IIf([First of Codecat]=1,[AccessTotalsmuamaladate_By_Month]*0.25,[calculate]), IIf([First of Codecat]=2,[AccessTotalsmuamaladate_By_Month]*1,[calculate]),IIf([First of Codecat]=3,[AccessTotalsmuamaladate_By_Month]*2,[calculate])
System only recognize the first condition. Appreciate your help and thankyou in advance.