Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi.
In my model, I select a set of "Codigo" and then I need to select 1, 2 or 3 "Imputacion" and when doing the "Imputacion" filter, in the "Cantidades" table it does not show me the "Codigo" that did not have data, but I need you to show me only from the set of "Codigo" selected.
Attached exampled.
Regards.
It is a hack, but might work for you
Sum(Cantidad) + If(Len(Trim(Only(TOTAL <Imputacion> Imputacion))) > 0, Sum({<Imputacion>} TOTAL <Codigo> 0.000000001))
hi
if you want to disregard selections in the field Imputacion
just change your expression to
Sum({<Imputacion=>}Cantidad)
It is a hack, but might work for you
Sum(Cantidad) + If(Len(Trim(Only(TOTAL <Imputacion> Imputacion))) > 0, Sum({<Imputacion>} TOTAL <Codigo> 0.000000001))