Skip to main content

Please assist, I am trying to use the switch formula on the report design, but i get an error when validating the formula. I don't know what i am missing. 

 

 

Try changing the “ to a single inverted ‘ around the Text and try it. You can also remove the ‘ commas from the 1, 2, 3 also but that should not make any difference

Hi @TitileGama ,

@dcomerford is correct, I am using below formula and able to validate successfully.

Switch( (CashAccountPaymentMethodDetail.DetailID]= 1,'Account Nbr','CashAccountPaymentMethodDetail.DetailID]= 2,'Account Type','CashAccountPaymentMethodDetail.DetailID]= 3,'Branch Code')

 

Regards,

Sagar 

Reply


Terms & ConditionsCookie settings