if(Concepto = 'VENTAS', 'Ventas Netas' & chr(10) & chr(10), if(Concepto = 'COSTO DE VENTAS', 'Costo de Ventas' & chr(10) & chr(10), if(Concepto= 'VENTAS' and Concepto= 'COSTO DE VENTAS', 'Utilidad Bruta' & chr(10) & chr(10))))
the problem is that 'Utilidad Bruta' not appers, i think the problem its because 'VENTAS' and 'COSTO DE VENTAS' match in the two first lines, so i trid to use this expression too but with not results
if(Concepto= 'VENTAS' and Concepto= 'COSTO DE VENTAS', 'Utilidad Bruta' & chr(10) & chr(10))))
the codes works but i need to use other lines, to solve it i used a table in line, but the concepts dont match since 'Utilidad Bruta' its a concept that dont exist so i use the expression to make it appers
what i mean? Concepto it linked to account numbers so 'VENTAS' and 'COSTE DE VENTAS', are linked to many and diferents accounts and 'Utilidad Bruta' its the sum of both as result, so its a caculate data, so 'Utilidad Bruta' not exist in the code like 'VENTAS' and 'COSTE DE VENTAS'