If statement

[maternmi]

Dear all,

we have orders which are invoiced and which are not invoiced yet. I would like to show within a diagramm at the invoice date field the invoice date, if there is one. If there is no one I want to display a text (no invoice yet) instead of "-".

how can I do it within a diagramm.

I've tried

=if([invoice date] = 0 ,'no invoice yet', [Fakturadatum])

but I dosen't works. Does somebody knows the solution?

Thanks for helping!

Best regards,

Michael

[kaushiknsolanki]

Hi,

     Try this.

     Load Invoice_Id,

             Invoice_Date,

             If(isnull(Invoice_Date),'No Invoice Yet','Invoice Generated') as Invoice_Flag

     From xyz.

Regards,

Kaushik Solanki

[#3 · Accepted solution]

Hi,

You need to use either the isnull() function or the alt() one.

If(isnull([invoice date]) ,'no invoice yet', [Fakturadatum])

the alt() function gives you the second result if the first one is empty;

Alt([Fakturadatum]), ‘no invoice’)

Fabrice

[jagan]

Hi,

You can also do the same by using Len() like this

if(Len([invoice date]) = 0 ,'no invoice yet', [Fakturadatum])

Regards,

Jagan.