Forum Discussion

GVTionale's avatar
GVTionale
Icon for Helper II rankHelper II
6 years ago

display only those columns where fields are not empty

I have a table containing payment terms of customer orders as follows -   Payment_Mode1 , Percentage of Mode1, Payment Mode2, % of Mode2 and Payment Mode3, % of Mode 3.   Payment Mode 1 will have...
Need Help
GVTionale's avatar
GVTionale
Icon for Helper II rankHelper II
6 years ago

Hi Pete

 

thanks so much for your prompt reply.

 

I have some more issues with the data as i went through it now  and presenting the same here 

 

(1)the source Table has values filled in for payment mode even where the % is 0

(2) the values in percentage column are whole numbers . how do i add the % symbol in the description

(3) Days field has been provided for all payment modes, though the value is 0 for Mode 1 and Mode 2 for all the rows

 

PAYMENT_MODEDAYSPERCENTAGEPAYMENT_MODE_2DAYS_2PERCENTAGE_2PAYMENT_MODE_3DAYS_3PERCENTAGE_3
TT0100DP 0LC-S00
TT030DP 0LC-U6070
TT00DP 100LC-S00

 

Kindly advise how to resolve this

 

regards

BA_Pete's avatar
BA_Pete
Icon for Super User rankSuper User
6 years ago

Hi GVTionale ,

 

Did this work out OK for you?

If so, can you mark the solution that worked please? This ensures that people are directed to the correct answer if they've got the same issue.

 

Thanks,

 

Pete