Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to limit a straight table by a dimension date.
The code I have written is =If(PRICING1_END_DT<=vToday,PRICING1_END_DT))
This isn't quite correct and it just removes the date if it is after vToday. I would like the table to only show data where the PRICING1_END_DT is less than today, rather than blank the data in the field.
Any help is much appreciated.
Regards,
Daniel
Are Suppress Zero-Values & Suppress When Value is Null checked?
Can you tell us something about the format of PRICING1_END_DT and vToday.
Hi Martin,
Thank you for your reply.
vToday = Date(Today()) - format of this field is DD/MM/YYYY
PRICING 1_END_DT is a date field in the format of DD/MM/YYYY
Is that all the information you require?
Regards,
Daniel
Try putting the limit in the expression. Suppose you want sum(Value) as expression. You can limit this to the required dates like this: sum({<PRICING1_END_DT={'<=$(vToday)'}>}Value)
You'll have to make sure that the variable vToday has the same date format as PRICING1_END_DT
Are Suppress Zero-Values & Suppress When Value is Null checked?
Hi,
Thanks that has solved the issue. Sorry for not spotting this basic error.
Regards,
Daniel