Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i have this situation :
CD_CODE | Prezzo2014 | Prezzo 2015 | Qty 2015 | Prezzo x Qty 2015 | Coverage |
S0440871 | - | 13,64 | -12 | -164 | -€ 164 |
S0302446 | - | 8,76 | 7 | 61 | € 35 |
When Prezzo2014 is equal to '-' , I want that Coverage is equal to zero.
How can i do?
I tried with Isnull Function or Len function but doesn't work.
Thanks a lot
I tried with your expression but there is a problem. I have a drill down group in my linear table and when click on the row to drill total result change. What is it the problem?