Set Analysis division

[#1]

Hello,

I'm trying to perform a division in Set Analysis, within a pivot table. Both of the below formulae are correct when displayed individually, but when I add the division '/' symbol, no value is returned.

Could someone please let me know the correct syntax?

(Sum ({<BILLED_TIME.PERIOD={$(YTD)}, TIME.PERIOD_FIN_YEAR = , INT_DATE => } BILLED_TIME.BILLED_AMT))
/

(Sum ({<BILLED_TIME.PERIOD={$(YTD-1)}, TIME.PERIOD_FIN_YEAR = , INT_DATE => } BILLED_TIME.BILLED_AMT))

Thanks, Gavin

[alexandros17]

The second formula returns 0?

[MK_QSL · Accepted solution]

Looks wrong in BILLED_TIME.PERIOD={$(YTD-1)}

What is your YTD variable.. i.e. can you let us know the definition of it?

[#4]

Thank you both. Manish, you were correct - a silly mistake by me; YTD-1 should have been PTYD.