Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
My Table have 2 column PY and CY , with the help from manish .
PY it have 5 row have value.
May i know how to remove all row which are null value ?
Remark :- In QV simialr table does not have null value. this only happen in QS.
Paul
Hi Paul,
Please check the attached file again on the last sheet. The target is to replace Null with 0 so the Show Zero untick works. I've changed the expression for UP SALES CY, Variances.
Let me know if this is what you're looking for.
My QVF
Hi Paul,
Is that the REMOVE ROW WITH NULL tab that you want us to look at?
If Yes then please look at the attached file, i remove Company Pay expression you used and just add Company Pay as dimension.
Also the expression to calculate sum, i've replace Null() & '' to 0, so the Show Zero works
if((Sum(curren)+Sum(days3)+Sum(days6)+Sum(days9)+Sum(above12))<>0, (if(Sum(curren)<>0,Sum(curren),0)),0)
Hope it makes sense to you
Hi Nhu
Thank you for your help. I am sorry I am
Refer to last sheet , sheet name = My Nee sheet (1)
Paul
Sent from my iPhone
Hi Paul,
Please check the attached file again on the last sheet. The target is to replace Null with 0 so the Show Zero untick works. I've changed the expression for UP SALES CY, Variances.
Let me know if this is what you're looking for.
Hi Nhu
wow you make a lot of changes. Thank you very much. Now okay
Paul