calculated dimension

[prma7799]

Hi All,

How to write below expression in dimension.

[First Invioce Date]={'>=$(=Date(vStartDate))<=$(=Date(vEndDate))'}

Thanks

[tamilarasu]

Try,

If([First Invioce Date]>=Date(vStartDate) and [First Invioce Date]<=Date(vEndDate),

    [First Invioce Date]

)

[prma7799]

Hi Tamil ,

Your suggestion is right but am taking   [First Invioce Date] ,Product and many more dimension for   [First Invioce Date] is showing perfect range but for product it will not display for that range .

kindly help.

[tamilarasu · Accepted solution]

I am not understand your requirment clearly.

You mean this,

If([First Invioce Date]>=Date(vStartDate) and [First Invioce Date]<=Date(vEndDate),

   Product

)

If not, could you elaborate or post sample application.

[#5]

Hi,

Try this,

{<[First Invioce Date]={'>=$(=Date(vStartDate))<=$(=Date(vEndDate))'}>}

KR,

Hasvine

[PrashantSangle]

Hi,

If possible move your condition either in script or in Expression.

if you want in expression you can try liike

Only({<[First Invioce Date]={'>=$(=Date(vStartDate))<=$(=Date(vEndDate))'}>} Product)

Regards

[#7]

Example:

Sum({<[First Invioce Date]={'>=$(=Date(vStartDate))<=$(=Date(vEndDate))'}>}XXXXX)