topic IF condition with date in Management & Governance

IF condition with date

zied_ahmed1 — Wed, 07 Jun 2017 11:16:04 GMT

Hello,

in a pivot table I have a date like 01/01/2017

i need an expression like this

if (Dimensionality()=1,' ',

(if (Dimensionality()=2 and date>'01/06/2017',

'Hello'

)))

But it doesn't work (when i delete the condition of date it display hello...

regards

sunny_talwar — Wed, 07 Jun 2017 11:17:13 GMT

May be use Makedate() function

if (Dimensionality()=1,' ',

(if (Dimensionality()=2 and date>MakeDate(2017, 6, 1),

'Hello'

)))

zied_ahmed1 — Wed, 07 Jun 2017 11:27:38 GMT

Thank you sunny but it doesn't work

sunny_talwar — Wed, 07 Jun 2017 11:30:33 GMT

is date a true date field?

zied_ahmed1 — Wed, 07 Jun 2017 11:31:27 GMT

yes yes it's like 01/01/2017

sunny_talwar — Wed, 07 Jun 2017 11:34:02 GMT

Then no idea

marcohadiyanto — Wed, 07 Jun 2017 12:26:43 GMT

Hi Zied,

May i know your dimensions?

I tried i can do with your expression when i put my date as my second dimensions.

You should try that.

But why you want to filter the date?

Regards

Marco