Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
I have a problem with this expression :
= sum(if([VOY.EPFCLE] <> 0, 1, if([PLA.EPFCLE] <> 0, 1, 0)) -> result 834
-> expected result 833
But in this case PLA.EPFCLE is always = 0 and if I do sum(if([PLA.EPFCLE] <> 0, 1, 0)) -> I have 0
So we are agree that my formula is equivalent to : sum(if([VOY.EPFCLE] <> 0, 1, 0) and I do it, I have the result 833 what is expected !!
VOY.EPFCLE is a key and never null so it 's not a problem like it. There is also no double value
It is very strange. It's like bug
Is there a way to explain it and maybe something to test ?
Best regards,
Mike
Try this
= sum(if([VOY.EPFCLE] = 0, if([PLA.EPFCLE] =0, 0, 1),1)
What do you get if you use the following expression:
RANGESUM(
COUNT(DISTINCT {< [VOY.EPFCLE] -= {0} >} [VOY.EPFCLE])
, COUNT( DISTINCT {< [VOY.EPFCLE] = {0} , [PLA.EPFCLE] -= {0} >} [PLA.EPFCLE])
)
Is there any combination of selections where you may have a valid value on PLA.EPFCLE and no valid values on VOY.EPFCLE?
Did either of the posts address the issue? If so, be sure to give them credit by clicking the Accept as Solution button on any that did help. If you figured it out yourself, please post what you did and mark that as the solution. If you require further help, please provide additional information.
Regards,
Brett