Question:
I am creating a condition on MTD sales in my query. The condition is
MTD <> 'blank'.
I am not able to create a condition on MTD sales KF which says show all records which satisfies MTD <> ' blank'.
How do we show blank in a condition ???????
Pls help me on this as I need to run this query by today.
Many thanx in adv.
Adios
Answer:
key figure default value is not blank, it is zero;
so create your condition saying MTD <> 0 , that's it
Answer:
key figure default value is not blank, it is zero;
so create your condition saying MTD <> 0 , that's it
I tried that MTD<>0.
But still I get results which says MTD 0. My MTD sales is in thousands and I am giving in the condition just MTD<>0. Is that the case???
Let me know if I am doing something wrong.
Answer:
One more thing CHC, I am also getting in the results (0). I know they are negative values that why I am getting in brackets. But I dont want to see anything that give me MTD sales 0 or (0).
Waiting for a reply .
Thanx in adv.
Adios
Answer:
One more thing CHC, I am also getting in the results (0). I know they are negative values that why I am getting in brackets. But I dont want to see anything that give me MTD sales 0 or (0).
Waiting for a reply .
Thanx in adv.
Adios
Answer:
One more thing CHC, I am also getting in the results (0). I know they are negative values that why I am getting in brackets. But I dont want to see anything that give me MTD sales 0 or (0).
Waiting for a reply .
Thanx in adv.
Adios