Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I need help...
I have a table with 2 fields – Count1, Date1.
I have 2 expressions which will give me Month & Year based on some other logic. Through this Month & Year I need to show in my text box as below:
Sum of monthly Count1 / Sum of Total records Count1 * 100 & ‘%’
Here is my expressions to get Month:
=IF(GetSelectedCount([Date]) > 0 ,Month([Date]),
IF(GetSelectedCount(Year) = 0 and GetSelectedCount(Month) = 0, Month(Today()),
IF(GetSelectedCount(Year) > 0 and GetSelectedCount(Year) = Year(Today()), Month(Today()),
IF(GetSelectedCount(Year) > 0 and GetSelectedCount(Year) < Year(Today()), SubField('$(MonthNames)',';',Max(Month))))))
To Get Year:
=IF(GetSelectedCount([Date]) > 0 ,Year([Date]),
IF(GetFieldSelections(Year)<Year(Today()),Year,Year(Today())))
Thanks,
Lakshmi.
In your expression, Year is remaining same, so it will give you result like
Jan 2014, Dec 2014, Nov 2014, Oct 2014.... Correct me if I am wrong...
Hi Manish,
It seems Year will be wrong. I didn't think about year changes. the correct way is Jan 2014, Dec 2013, Nov 2013 and Oct 2013.
How to achive it? I am very new to this. pls help.
Thanks,
Lakshmi.
Hi Anbu,
can you pls help?
It seems Year will be wrong. I didn't think about year changes. the correct way is Jan 2014, Dec 2013, Nov 2013 and Oct 2013.
How to achive it? I am very new to this. pls help.
Thanks,
Lakshmi.