Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have stuggleing with the below function:
sum(aggr(sum(DISTINCT ([qty])/([unitsן]*[car]*[layers])),item,[month]))
I would like to add to above function that if the units are NA-->pls give me 10 units (iferror function in excel)
f the car are NA-->pls give me 10 car (iferror function in excel)
f the layers are NA-->pls give me 7 layers (iferror function in excel)
Thanks a lot!
Hi,
you can use exactly that in the load srcipt :
if(isnull(Units) or wildmatch(Units,'NA'),10,Units) as "new Unit",
if(isnull(cars) or wildmatch(cars,'NA'),10,cars) as "new cars",
if(isnull(layers) or wildmatch(layers,'NA'),10,layers) as "new layers"
Use these new fields in that formula so that other areas are not impacted..