Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone - looking to get some help with this expression
What I'm trying to show is a value of the vMaxSelectedDate calculation if the first calculation shows a null.
The first calculation takes the last day of the month
The second calculation takes the last selected day of the month.
I hope the below expression is clear for you to read. Please let me know if there are any questions.
=if((sum({$<LAST_WORKING_DAY_MONTH={1},FactTypeID={1},bRentable={Y}>}dcMonthlyRate*Occ_Flag)
/
sum({$<LAST_WORKING_DAY_MONTH={1},FactTypeID={1},bRentable={Y}>}Occ_Flag)) <=0,
(sum({$<Date={'$(vMaxSelectedDate)'}>}dcMonthlyRate*Occ_Flag)
/
sum({$<FactTypeID={1},bRentable={Y},Date={'$(vMaxSelectedDate)'}>}Occ_Flag)),
(sum({$<LAST_WORKING_DAY_MONTH={1},FactTypeID={1},bRentable={Y}>}dcMonthlyRate*Occ_Flag)
/
sum({$<LAST_WORKING_DAY_MONTH={1},FactTypeID={1},bRentable={Y}>}Occ_Flag)))
The result I get shows the months up to the last selected month, at which point it shows a null value.
It will likely help if you can attach the qvw file or a sample one with the data model etc. as well. This generally makes it easier for folks to help, as they can look everything over to be sure they are providing the correct solution...
Regards,
Brett