Hi all i try this but this shows an error
=If
(
$(vYTD)=1,
'YTD GP ('&Max(Year_U)&'): '&
Num((Sum({<Year_U= {$(vPrevYear)},Month_U=,Quarter_U=>}
RangeMax(0,RangeMin((PEX_Date- PEff_Date+ 1),($(vPE_Date)- PEff_Date+1)))
/ (PEX_Date- PEff_Date+ 1)*GROSS_PREMIUM)),'#,##0.0')
&CHR(10)&
'YTD GP ('&(Max(Year_U)-1)&'): '&
Num((Sum({<Year_U= {$(vPrevYear)},Month_U=,Quarter_U=>}
RangeMax(0,RangeMin((PEX_Date- PEff_Date+ 1),($(vPE_Date)- PEff_Date+1)))
/ (PEX_Date- PEff_Date+ 1)*GROSS_PREMIUM)),'#,##0.0')
&CHR(10)&
'Variance : '& Num((Sum({<Year_U= {$(vMaxYear)},Month_U=,Quarter_U=>}
RangeMax(0,RangeMin((PEX_Date- PEff_Date+ 1),($(vPE_Date)- PEff_Date+1)))
/ (PEX_Date- PEff_Date+ 1)*GROSS_PREMIUM) -
Sum({<Year_U= {$(vPrevYear)},UW_Month=,Quarter_U=>}RangeMax(0,RangeMin((PEX_Date- PEff_Date+ 1),($(vPE_Date)- PEff_Date+1)))
/ (PEX_Date- PEff_Date+ 1)*GROSS_PREMIUM)),'##,##0')
)
Error is
Error in express: / is not a valid function
