Skip to Content
0
Former Member
Nov 09, 2004 at 02:46 AM

Formula for looping over zero value

29 Views

Hello,

In BPS, I have a layout with 7 key figures in the lead columns, and the 12 posting periods across the data columns. If I have a numeric value variable entered in the web page, I want to place that value in 1 of the key figure for all 12 periods. But since the whole table contains zeros it doesn't work. It will only work for a column where there is a non zero value in 1 of the key figures. Any assistance?

Thanks,

Linda